Hello I am using Excel report generation toolkit to create a template report. Its a DAY report, in which the a SINGLE ROW will be added to existing/new report after every test, i.e. ever time the subvi executes, a single row will be added to the excel file My Issue 1. I am able to create the new excel file from the template and add the single line report, but whenever the vi executes, it throws an error while saving the excel file "Save report to File.vi" 2. I have tried to use clear error vi to remove this error. But some how after some while, the report stops generating and a *.tmp file starts getting created 3. I have attached some reports generated To test my code, in the cluster, change the "DAY REPORT TEMPLATE FILE" . Select browse button on the Path Control and choose "DAY_REPORT_TEMPLATE.xlsx" file I am using LabVIEW 2020 SP1 32 bit and Microsoft® Excel® 2021 MSO (Version 2410 Build 16.0.18129.20100) 64-bit Kindly provide help on this issue.

Your mention of using .csv files (perhaps generated using "Write Delimited Spreadsheet" may explain why you are having problems and how you might be able to "have your .slxs and add to it, too". First, notice that to develop an "incrementing Delimited Spreadsheet" file requires nothing more than (a) using basic LabVIEW File I/O (using strings) and (b) a quick-and-easy way to close a file, reopen it, and quickly reposition to the end-of-file in order to continue additional data. Now bring the RGT and Excel into the picture. The RGT doesn't do the file I/O -- it instead passes data to Excel and instructs it how to format the data, then asks Excel to save the just-created file. What you could do is to use the "Template" feature of the "Create Report" function. Here's how you might do this: The first time you write to a Spreadsheet, use ordinary RGT commands. When finished, "Save Report to File" (let's call it "My Data.xlsx") and then "Dispose Report" (which shuts down Excel, a process that might take a few hundred milliseconds -- you'll want a delay here. So now you want to add more data to this (now-existing) Excel Workbook. How will you do this? Will you make a new WorkSheet? [There are RGT functions to help with this]. Are you going to use the same WorkSheet, perhaps adding new rows to the existing Sheet? [There are also RGT functions to help with this]. So now do a new "Create Report", but specifying the existing WorkBook as the Template. Add whatever data you want, either in a new WorkSheet or appending rows to the existing WorkSheet used before. Here, however, I'm uncertain whether or not "Save Report to File" will work if you specify the same filename as the "Template" you just opened. If that doesn't work, you can always save to a temporary Report, close Excel (and wait for it to "let go" of the temporary .xlsx file), then rename the file to the name it had when originally opened two steps earlier. I haven't actually tried this, but it should work (Famous Last Words). Be sure to give Excel a "rest" between "Dispose Report" and the next "Create Report". Bob Schor

LabVIEW

Excel Report Generation Error

Solved!

Hello, @AndreeaH, and welcome to the LabVIEW Forums.

Here are some suggestions:

If you have a question on a new topic, don't say "Sorry, it's not related to the topic", but start your own new topic.
When specifying a new topic, make sure you clearly specify what you are trying to do (see suggestions below).
It helps us to help you if we know something about your LabVIEW experience and training. How many years (or months, or days) have you been using LabVIEW? What version(s) of LabVIEW are you using?
If you have "code that doesn't work", do your best to show us the code. The best way is to include actual LabVIEW code (not "pictures" of block diagrams, but actual VIs).

Specific suggestions:

You mention "working in labview (there is no such thing as "labview", you probably mean LabVIEW) with an emg signal (explain what this is -- not everyone is an electrophysiologist). What is the amplitude of this signal? What are the relevant frequencies of the signal? How are you recording it?
What do you mean by a "motor unit"? [I've never heard of a muaps, but Google seems to suggest that MUAP can mean Motor Unit Action Potential]. Here is where a picture of the signal you are trying to acquire and analyze (showing one or more MUAPs and giving some idea of how you identify and separate them if more than one is present in a recording).
If you don't understand the signals you are trying to study and isolate, it is not clear that a LabVIEW "expert" will be of much help to you. I'd recommend looking up scientific papers that deal with these signals and learning how others have dealt with the "separation" (or "filtering") questions you seem to be raising.

Please do not respond to this Post, whose title is "Excel Report Generation Error". Instead, start your own Post. If you want, you can copy this "Excel Report" reply and paste it in your new Message to get you started.

Bob Schor