Combine multiple excel worksheet into one excel file

[ethibault123]

Hi,

I'm using labview 2011 and I do have the report generation tolkit. My software create 3 or 4 excel files separetly. Is there a way to combine all those excel in one excel (take all the worksheet of all excel files and merge them all into on new excel file...)

Can't figure a way to do it... no function is doing it.

Thank you

Eric

[ben64]

---

@ethibault123 wrote:

Hi,

I'm using labview 2011 and I do have the report generation tolkit. My software create 3 or 4 excel files separetly. Is there a way to combine all those excel in one excel (take all the worksheet of all excel files and merge them all into on new excel file...)

Can't figure a way to do it... no function is doing it.

Thank you

Eric

---

I think it would be a lot easyer to modify your software to create these files as worksheets in the same workbook. I strongly recommend this approach.

Ben64

[ethibault123]

I Can't unfortunatly... of course if I could I would, that was mt first idea. But i'm running multiple kind of tests and need a diffenrent excel template for each of those tests.

Originally, I had I master Excel with every worksheet template. But when come the time to save the report, as the other worksheet are blank, it do not update my test report. It erases all other worksheet and saving my ''active test'' worksheet...

That is why I decided to save all my test on a separated excel containing only 1 worksheet (originally, the template and then updated with my test results...)

[ben64]

---

@ethibault123 wrote:

I Can't unfortunatly... of course if I could I would, that was mt first idea. But i'm running multiple kind of tests and need a diffenrent excel template for each of those tests.

Originally, I had I master Excel with every worksheet template. But when come the time to save the report, as the other worksheet are blank, it do not update my test report. It erases all other worksheet and saving my ''active test'' worksheet...

That is why I decided to save all my test on a separated excel containing only 1 worksheet (originally, the template and then updated with my test results...)

---

What have you tried to fix this?

Ben64

[ChaoyD · Accepted solution]

Are you making sure your worksheet with previous data isn't the active worksheet? That would erase your previous test data and put the new test data in its place.

The easiest approach is a workflow similar to this:

1) Check if Excel file exists

1a) If it does, create a new worksheet

1b) If it doesn't, create a new Excel workbook

2) Append data

3) Save report

4) Close report

The Report Generation Tool has VIs that do most all of these functions. To check if the file exists, it is in a separate pallet.

[ethibault123]

Thank for answering, it lighted the light bulb above my head... it was so easy after all...

[Poojaavi123]

Hi,

I am facing same problem, I have 3 Excel sheet and want to merge in one , but Function of Append data is not listed in RGT Append report Text, Append Table, Append Image is showing so what Function I have to use for merging the Excel Sheet.

Thanks and Regrads

Pooja Katariya

[GerdW]

Hi Poojaavi,

---

@Poojaavi123 wrote:

what Function I have to use for merging the Excel Sheet.

---

What would you do in Excel?

You would copy the content of one worksheet and paste in the other worksheet at the required cell location. Why don't you try the same in LabVIEW?