How to split data into different sheets in excel?

[mimi345]

Hello,

I've created a program that can generate report into excel. but all the data is display only in one sheet and i want to split it into different sheets. I'm using Labview 2012.Thank you in advance.

[GerdW]

Hi emme,

you need to write those data into seperate worksheets!

Maybe you should attach your VI for further suggestions…

The main point is: HOW did your write your data "into excel"? Which functions did you use?

[woan · Accepted solution]

Hi emme345,

Maybe you can try to insert a function vi called Excel Add Worksheet after the New Report vi in order to create a new Excel worksheet.

You are also able to select which worksheet you want to write to by inserting a vi called Excel Get Worksheet.

Please refer to the link below as your reference. You can download the attached vi and modify it for your application.

Write to a Sheet other than Sheet1 of an Excel Spreadsheet (Report Gen)

https://decibel.ni.com/content/docs/DOC-5468

Write Data Into New Worksheet of Existing Excel Workbook

https://decibel.ni.com/content/docs/DOC-20014

Hope this helps.

Warmest Regards,

Rebecca

Applications Engineer

Nationall Instruments