Reading from a Text file & writing to Excel spreadsheets
Hi there,
I'm trying to read numeric data from a text file & I want to write each number in a seperate cell in an Excel spreadsheet. Can somebody help ???
Input data is as below:
3008,45,14,277,10,6371,223,208,116,3036,1,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,1,0,0,0,0,0,0,0,0,0,0,0,2
2893,114,16,108,30,5066,245,223,102,4340,1,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,1,0,0,0,0,0,0,0,0,0,0,0,2
I want each value in a different cell.
Please help. Its kinda urgent:confused::confused::confused:
With regards
jspnooby
Re: Reading from a Text file & writing to Excel spreadsheets
Please read the forum rules - double posting is not allowed. Your other post has been deleted.
I also recommend defining where you are stuck (reading a file, writing excel?) as we have no clue where the problem truly resides. And last but not least - everyone's question is urgent to them. Stating your problem is urgent can be considered rude to everyone else here seeking help, and everyone trying to help them.
Re: Reading from a Text file & writing to Excel spreadsheets
If you are interested in reading/writing Excel Spreadsheets, you should do some research on the different external libraries that are available. If you spent enough time reading and understanding the text-design of Excel files, you could probably figure out how to read/write to them without using an external library, but just getting a good external libraries would be a thousand times less time consuming.