I am trying to read serial port and save its data to excel file. I have successfully read the data and saved it into the excel file but when i tried to open it. It is giving warning message "The fle is in different format". I dont know it is saving in pdu file format. kindly reply me how to read data in excel file. Concerned VI is attached
The Write to Spreadsheet File does not create Excel workbooks. It creates delimited text files. If it's formatted properly then you should be able to open the file using Excel. Did you take a look at the file in a text editor? Note that just using .xls as the extension does not magically change it to an Excel workbook. If you truly need to create an Excel workbook then you need to either buy the Report Generation Toolkit, or use ActiveX directly to control Excel. You can find a lot of examples on how to do the latter in the Excel thread. NOTE: DO NOT POST QUESTIONS in the Excel thread. It is a thread for links only.
What Smercurio said is perfectly right, but you just get a warning, your data is in the file why do you need to worry. If you want excel then follow the things what Smercurio suggested.
I am also trying to do this but i am also facing problem in writing data in excel file...My program always print ###### instead of writing values coming from serial port....kindly help me...its urgent...my program is attached...
