Import Data From Excel

Started by Peter Johnson, December 19, 2016, 10:08:03 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Peter Johnson

Hey Guys

In my school, the time table responsible have problem for working with FET, since I want to import data from a sample excel file is prepared for him.
It means he fill the excel sheets then import data to FET and go a head.

I am working on import section (import.cpp) for implement this operation, but I have a lot of problem for understanding this section. For example I am making a method with named "readExcelFields" for reading data from excel file (like method "readFields" is written), but I cannot understand how should I set different variables in there.


Could you help me.
Thank you

Volker Dirr

you can't read an excel file as easy as an csv file. so you can't code that the same way.
a workaround might be exporting the excel file as a csv file / text file and import that one.
then you can code the reading of fields the same way. but i guess it will be pretty tricky to import it (since i guess you excel sheet will look like at FET activity planning dialog or an other FET statistics sheet.).