Go Down

Topic: Excel (Read 1 time) previous topic - next topic

PaulS

Quote
But is there a way to solve this without importing??

Yes, there is. Open a .xls file in notepad. See all the special characters? Figure out what they mean, and write the corresponding data to the file you create, with the .xls extension.

dxw00d


Quote
But is there a way to solve this without importing??

Yes, there is. Open a .xls file in notepad. See all the special characters? Figure out what they mean, and write the corresponding data to the file you create, with the .xls extension.


I started to do that once, and gave up. This document may help if you want to take that route - http://www.openoffice.org/sc/excelfileformat.pdf.

wildbill

As long as it has a csv extension, Excel will open it without a need to import

dxw00d

I know what the OP means though. If you double-click on a csv file, sometimes Excel will put each line in to a single cell.

PaulS

Quote
If you double-click on a csv file, sometimes Excel will put each line in to a single cell.

That depends on how you've told excel to handle csv files. I don't think that excel defaults, properly, to expecting a comma between the comma separated values in the csv file. For some reason, it expects, IIRC, that the c stands for semicolon.

Go Up