Re: Spreadsheet_Excel_Reader problem
| From: | tedd | Date: | Thu, 18 Mar 2010 15:40:26 +0000 |
| Subject: | Re: Spreadsheet_Excel_Reader problem | ||
| References: | 1 2 3 4 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-302962@lists.php.net to get a copy of this message | ||
At 11:35 AM +0000 3/18/10, Ashley Sheridan wrote:
The .csv format is just a plain text format, so you won't get formatting or formulas in your 'sheets' (csv is also a sheetless format) but it's been used for years by many systems for data. A lot of database systems will let you import csv files as well, which is quite convenient, although you will have to make sure the csv uses commas to delimit the data. Microsoft managed to basterdise this format a bit as well, and lets you use tabs, spaces and all sorts of other characters to delimit data fields. Someone obviously didn't mention to them that the file type is 'comma separated values'! Thanks, AshAsh: I remember many years ago I had a problem with M$ version of plain text csv files -- the first cell of each spreadsheet was different than all other cells. It took me a while to discover that difference and build in an exception. I've found that M$ always has a better idea, even if they are the only ones who think so. Cheers, tedd -- ------- http://sperling.com http://ancientstones.com http://earthstones.com