LabVIEW
different worksheet for every loop
Worksheet Index Defines the Array of worksheet Indices of your choice.
All rows Defines the Value.
While PalanivelIT's response is (mostly) correct, it may well fail "in the real world". You need to think about Excel's behavior when creating a new Workbook and Worksheets (which may well differ with different versions of Excel -- I'm using Office 2013, which shares behavior with Office 2007 and 2010).
When you open Excel and don't specify a Workbook (using New Report without specifying a Template), Excel gives you a 3-Worksheet Workbook, with Sheet 1, Sheet 2, and Sheet 3. In the example shown below, I've got an array of "Station Numbers" (nominally 1 through, say, 14, but possibly with a few Stations not in the array, e.g. 1, 2, 5, 7, 8, 10, 14). I want to create a Workbook with Worksheets named "Station 1", "Station 2", "Station 5", etc. When I create a New Report, I get the Worksheets Count (3 in Excel 2013, but why assume?), and using the Array of Stations to drive a For loop, I either use Get Worksheet (for the first three loops) or Add Worksheet (for the remaining Stations). I then build the Sheet Name ("Station %2d") and rename it with Excel Rename Worksheet. [In this particular VI, I also initialize the Worksheet by creating Column Headers and setting some Formatting choices).
Once I have all of the Worksheets initialized, another VI takes the array of data (one "chunk" for each Worksheet, which are now all appropriately named) and simply fills each Worksheet in the Workbook. [If you can't tell, I'm a great believer in having multiple subVIs that each do a little defined piece of the Puzzle -- in this instance, I have one VI that determines which Stations are present, this VI that initializes the Workbook (and creates named Worksheets, one per Station), the VI described at the beginning of this paragraph that takes the array of Stations, gets a Station-sized "chunk" of data, and writes it on the Station's Worksheet, and a final VI that closes the Workbook, looking similar to the final two Report Functions shown by PalanivelIT.]
Bob Schor
ransher a écrit :
hi bob,thanks for reply.
i tryed the way you explained above but didn't find out the solution ,the problem still exist .
Instead of creating different worksheet the program stores the data in single worksheet .
i have attached the vi and excel file.
The problem is not with Bob's code, it's how you use it and all the rube coding. What you want can probably be accomplished within a single loop. We don't have a clear idea of what you exactly want to accomplish. You should attach your csv file with typical data and an xlsx file that contain a few pages of the format you expect.
You also seem to use Bob code without really understanding what it does. The false case is not wired trough and what do you think the worksheets numeric control is used for? The way you use it all the sheets will have the same name, probably not what you want. Also, the same array will be written to all sheets.
Ben64
