Started by kdsayang, April 07, 2008, 12:47:19 PM
0 Members and 1 Guest are viewing this topic.
QuoteU have to change the 1000 Separator from , to |. U can change that in Regional and Language Option in Control Panel (Windows XP). Then in Regional Options TAB, click customize. Change , in List separator drop down menu to |
Quote1st. What I did was not changing anything in M$ Excel 2007. FYI, for changing the separator setting, I just need to change it in Windows in Control Panel --> Regional and Language Options. I don't need to change anything on M$ Excel 2007.
QuoteWhen I don't change anything, the output is the same as the input. [...]2nd. When I change the setting [...]
QuoteIt seems that *.csv can only save one worksheet in one *.csv file. [...], we can have 6 different files because *.csv file only support one worksheet.
Quote[...] Unlike *.xls (excel) where we can have many worksheet in only one file.[...] Unlike *xls where it can save that 6 different files into just one file because it support multiple worksheet.So, my suggestion that, for future FET release, FET can import and export *.xls file
QuoteI found only unofficial xls format file descriptions (no official one from Microsoft) and i don't use Microsoft excel.Also that file format is much more difficult than csv.
QuoteAn other solution is to use not worksheet one. use only worksheet 2 to 7. Before exporting you just copy your 6 sheets into sheet 1. You can code also an macro for this in excel so you don't need to do that always manually.