FET Forum

FET Support (English) => Programming Help => Topic started by: Peter Johnson on December 19, 2016, 10:08:03 AM

Title: Import Data From Excel
Post by: Peter Johnson on December 19, 2016, 10:08:03 AM
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
Title: Re: Import Data From Excel
Post by: Volker Dirr on December 19, 2016, 02:40:18 PM
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.).