Instead of fussing with CSV files, just use the Excel File.the first file will be in \My Data\Run 1.csv). Use Write to Delimited Spreadsheet to create a CSV file named for the WorkSheet (i.e. In a While Loop, open each Sheet and read the data. Note that I'm assuming you have the Report Generation Toolkit, which allows you to read and write Excel (.xlsx) files. Let's assume your Excel file is called My Data.xlsx, and it has four sheets, Run 1, Run 2, Run 3, and Run 4. This is sounding already too complicated. You seem to be hung up on how to handle the multiple Sheets, and seem to be looking for a generalization of the CSV format that would allow you to have a single File with multiple CSV-formatted data inside it. You mention that the Excel file has multiple Sheets, and that you want to process all (?) or some (?) of them (this is not clear). So here's my question: what do you really want to do? Do you have an Excel (.xlsx) file? Does it have any Excel-specific "features" (such as formatting, column widths, coloring, graphs, etc.)? What do you really want to do with it? However, any "Excel-specific" changes you make (like formatting) won't be saved when you close the file unless to save it as a. Excel can "recognize" this Text file, can open it, and can allow you to use Excel to examine and modify the data. However, Microsoft decided to associate an "Excel-like" icon with this file type. A CSV file has nothing to do with Microsoft Excel.A CSV file is a "Comma-separated Values" file, a plain text file that uses a delimiter (often a comma, hence the name, but other characters, such as a, the LabVIEW default, are also commonly used, particularly when the data "being separated" contains commas (like numeric string representations in Europe).I'm a little bit confused on what you want to do.
0 Comments
Leave a Reply. |