I currently convert an excel file to a mysql table in the following way.

Open excel and delete not needed columns.
Select date columns and format them to YYYY-MM-DD.
Export to a csv file.
Edit the csv file to remove the first line.
Load the csv file to a mysql table.

I would appreciate it if someone can point me to ways that some of the
previous steps could be done by a C/C++ program.

I apologize if this is not the right forum for this question.

Thank you,
Joe

On Thu, 07 Jul 2011 14:42:25 -0500, Joseph Hesse wrote:
The fourth step there could probably be effectively managed with a C/C++
program. The others are already pretty well-optimized within the range
of what's determinable at compile-time or without much human input.

--
71. If I decide to test a lieutenant's loyalty and see if he/she should
be made a trusted lieutenant, I will have a crack squad of marksmen
standing by in case the answer is no.
--Peter Anspach's list of things to do as an Evil Overlord

On 2011-07-07 21:42, Joseph Hesse wrote:
In Java and Python there are libraries that can be used to manipulate
excel files. There probably exists something similar for c++ as well
(havent tried one though). I googled for excel c++ and found for example:

http://xlw.sourceforge.net/

If you find a library that works you probably can automate all steps in
the process.


/Lennart

On Jul 7, 6:08*pm, Lennart Jonsson <erik.lennart.jons... (AT) gmail (DOT) com>
wrote:


load file ignore 1 lines into a tmp table, (see docs for the
"ignore" syntax.
insert into realtable select a,b,d,e from tmptable;
drop tmptable.

Don't make it more difficult than needed.

On 2011-07-08 01:48, onedbguru wrote:
and the conversion from BIFFx (or whatever it is called these days) to csv?


/Lennart

Le Thu, 07 Jul 2011 14:42:25 -0500, Joseph Hesse a écritÂ*:

Yould try an ODBC link between Mysql and your excel sheet
André

Joseph Hesse wrote:
The last to are amenable to automation with a program.

And the second,

But not the first and third

On Jul 8, 8:50*am, The Natural Philosopher <t... (AT) invalid (DOT) invalid>
wrote:
It is ALL doable, if you have the right tools... found this:
http://capmarketer.com/converting-xl...ls2csv-ubuntu/

While it says ubuntu, it should work with any Linux distro.


the do something like:
perl xlstocsv ifile ofile
mysql
load file ignore 1 lines into a tmp table, (see docs for the
"ignore" syntax.
let the mysql handle the date coversion
insert into real-table select a,b,d,e from tmptable; (notice I
skipped one column)
drop tmptable.

Again, don't make it more difficult than needed.

On Fri, 8 Jul 2011 14:18:45 -0700 (PDT), onedbguru wrote:
You are ignoring the "using C/C++" part, aren't you?

--
26. No matter how attractive certain members of the rebellion are,
there is probably someone just as attractive who is not desperate to
kill me. Therefore, I will think twice before ordering a prisoner
sent to my bedchamber. --Peter Anspach's Evil Overlord list

On Jul 9, 2:53*pm, "Peter H. Coffin" <hell... (AT) ninehells (DOT) com> wrote:

Since it doesn't require c/c++ - yes. Again, don't make it more
difficult than needed - and programming the thing in c/c++ would be
overkill.