import and export files

Started by kdsayang, April 07, 2008, 12:47:19 PM

Previous topic - Next topic

0 Members and 2 Guests are viewing this topic.

kdsayang

1st. 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.

When I don't change anything, the output is the same as the input.
A1:  Hallo
A2:  Mr. "genius" Brown
B1:  4
B2:  4.5

2nd. When I change the setting

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 |
It changed to
A1 : Hallo,4
A2 : Mr. "genius" Brown,4.5

Below is the file....

Volker Dirr

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.

ok.

Quote
When I don't change anything, the output is the same as the input.
[...]
2nd. When I change the setting
[...]

ok. so windows (and/or excel) also use the same default field and text separators like openOffice.

i will change my source.
changing the export filter will be easy.
changing the import filter will be a more difficult then the previous/current version.

i will do that in the next days.


kdsayang

It seems that *.csv can only save one worksheet in one *.csv file. Unlike *.xls (excel) where we can have many worksheet in only one file.

What I'm trying to say that, in *.csv, we can have 6 different files because *.csv file only support one worksheet.

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

TQ

Volker Dirr

#18
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.

That is correct. you can store only one sheet into csv.

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

That is a TODO, but i already know that i will not do that this year.

I 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.

So it look like an other guy must code that if you need it quick.

Maybe you can also ask Microsoft, if they code an export function into a single cvs file? That import function will be much easier to code, because they already have an export to csv of worksheet one. They just need to add a few more lines of code to do that.
Writing an import filter (in FET) need at least several hundred lines of code.

An 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.

kdsayang

Quote

I 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.

Found the official Microsoft Office Binary (doc, xls, ppt) File Formats at http://www.microsoft.com/interop/docs/officebinaryformats.mspx

Quote
An 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.

I don't quite understand that. Can u elaborate more with more examples??

TQ

Volker Dirr

#20
if i understand correct, then this is your problem:

You use 6 sheets (i guess you separated the years. So sheet 1 is year 1. Sheet 2 is year 2. ...)
You problem is, that only sheet 1 is exported to csv by excel.
Sheet 2, ... are not exported.

so most easiest solution is to just copy manually the data of sheet 2 into sheet 1. Also data of sheet 3 into sheet 1, and so on.
but this way is not very clean if you want to modify later.
that is why i said: "don't use sheet 1".
so sheet one just be empty. sheet 2 should contain data of the first year and so on.

After you finished your lesson planing you just copy sheet 2 into sheet 1, sheet 3 into sheet 1 and so on.
then you can export to csv.

Of course copy manually is not pretty nice. so it is more comfortable if you copy by a macro or if you code that. You can code in excel. If i remember correct it is an "basic" language dialect. (i code ~10 years ago with excel a little bit, but i don't remember everything.) So you only need to code run through all 6 sheets and copy every line into sheet 1.

kdsayang

Hi,

How is the latest version (5.5.5.) with import/export progress?? Can't wait to try that feature...  ;D

Volker Dirr

i am pretty busy at the moment.

but i already modified the source. Now you can export and import also with text quotations.
so it's possible to import csv "correct" into a spread sheet by default.

you can check it if you want. i release version vd2 at my page. But source only.

Liviu already found some changes that must be done in the interface. So i need to do that before i convert to the latest version.