Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.c > #98476 > unrolled thread

Using C to convert excel spreadsheet into mysql

Back to article view | Back to comp.lang.c

Contents

  Using C to convert excel spreadsheet into mysql Alla _ <modelling.data@gmail.com> - 2016-12-09 02:50 -0800
    Re: Using C to convert excel spreadsheet into mysql Richard Heathfield <rjh@cpax.org.uk> - 2016-12-09 11:13 +0000
      Re: Using C to convert excel spreadsheet into mysql Alla _ <modelling.data@gmail.com> - 2016-12-09 03:50 -0800
        Re: Using C to convert excel spreadsheet into mysql Barry Schwarz <schwarzb@dqel.com> - 2016-12-09 08:43 -0800
          Re: Using C to convert excel spreadsheet into mysql Alla _ <modelling.data@gmail.com> - 2016-12-09 09:09 -0800
      Re: Using C to convert excel spreadsheet into mysql Alla _ <modelling.data@gmail.com> - 2016-12-09 07:06 -0800
        Re: Using C to convert excel spreadsheet into mysql Richard Heathfield <rjh@cpax.org.uk> - 2016-12-09 15:50 +0000
          Re: Using C to convert excel spreadsheet into mysql Alla _ <modelling.data@gmail.com> - 2016-12-09 09:07 -0800
            Re: Using C to convert excel spreadsheet into mysql Richard Heathfield <rjh@cpax.org.uk> - 2016-12-09 17:23 +0000
              Re: Using C to convert excel spreadsheet into mysql Alla _ <modelling.data@gmail.com> - 2016-12-09 09:29 -0800
              Re: Using C to convert excel spreadsheet into mysql Lew Pitcher <lew.pitcher@digitalfreehold.ca> - 2016-12-09 12:43 -0500
                Re: Using C to convert excel spreadsheet into mysql Alla _ <modelling.data@gmail.com> - 2016-12-09 10:00 -0800
                  Re: Using C to convert excel spreadsheet into mysql Manfred <noname@invalid.add> - 2016-12-09 19:49 +0100
                Re: Using C to convert excel spreadsheet into mysql Richard Heathfield <rjh@cpax.org.uk> - 2016-12-09 18:15 +0000
              Re: Using C to convert excel spreadsheet into mysql Alla _ <modelling.data@gmail.com> - 2016-12-09 09:55 -0800
                Re: Using C to convert excel spreadsheet into mysql Richard Heathfield <rjh@cpax.org.uk> - 2016-12-09 18:22 +0000
                  Re: Using C to convert excel spreadsheet into mysql Alla _ <modelling.data@gmail.com> - 2016-12-11 00:23 -0800
                    Re: Using C to convert excel spreadsheet into mysql Keith Thompson <kst-u@mib.org> - 2016-12-11 01:33 -0800
                      Re: Using C to convert excel spreadsheet into mysql Alla _ <modelling.data@gmail.com> - 2016-12-11 03:38 -0800
                        Re: Using C to convert excel spreadsheet into mysql Keith Thompson <kst-u@mib.org> - 2016-12-11 12:35 -0800
                          Re: Using C to convert excel spreadsheet into mysql Alla _ <modelling.data@gmail.com> - 2016-12-12 01:08 -0800
                            Re: Using C to convert excel spreadsheet into mysql Richard Heathfield <rjh@cpax.org.uk> - 2016-12-12 10:14 +0000
                              Re: Using C to convert excel spreadsheet into mysql Alla _ <modelling.data@gmail.com> - 2016-12-12 02:42 -0800
                                Re: Using C to convert excel spreadsheet into mysql Keith Thompson <kst-u@mib.org> - 2016-12-12 09:02 -0800
                  Re: Using C to convert excel spreadsheet into mysql Alla _ <modelling.data@gmail.com> - 2016-12-11 00:23 -0800
                Re: Using C to convert excel spreadsheet into mysql "James R. Kuyper" <jameskuyper@verizon.net> - 2016-12-09 13:44 -0500
                  Re: Using C to convert excel spreadsheet into mysql Lew Pitcher <lew.pitcher@digitalfreehold.ca> - 2016-12-09 13:57 -0500
                    Re: Using C to convert excel spreadsheet into mysql Alla _ <modelling.data@gmail.com> - 2016-12-11 02:57 -0800
                    Re: Using C to convert excel spreadsheet into mysql BartC <bc@freeuk.com> - 2016-12-11 11:43 +0000
                    Re: Using C to convert excel spreadsheet into mysql Richard Heathfield <rjh@cpax.org.uk> - 2016-12-11 15:51 +0000
                  Re: Using C to convert excel spreadsheet into mysql Alla _ <modelling.data@gmail.com> - 2016-12-11 02:42 -0800
            Re: Using C to convert excel spreadsheet into mysql Richard Heathfield <rjh@cpax.org.uk> - 2016-12-09 18:09 +0000
              Re: Using C to convert excel spreadsheet into mysql Alla _ <modelling.data@gmail.com> - 2016-12-09 10:15 -0800
              Re: Using C to convert excel spreadsheet into mysql Keith Thompson <kst-u@mib.org> - 2016-12-09 12:16 -0800
                Re: Using C to convert excel spreadsheet into mysql Richard Heathfield <rjh@cpax.org.uk> - 2016-12-11 15:56 +0000
                  Re: Using C to convert excel spreadsheet into mysql luser droog <luser.droog@gmail.com> - 2016-12-11 08:27 -0800
                    Re: Using C to convert excel spreadsheet into mysql Richard Heathfield <rjh@cpax.org.uk> - 2016-12-11 16:37 +0000
                  Re: Using C to convert excel spreadsheet into mysql Keith Thompson <kst-u@mib.org> - 2016-12-11 12:40 -0800
                    Re: Using C to convert excel spreadsheet into mysql Alla _ <modelling.data@gmail.com> - 2016-12-12 01:13 -0800
        Re: Using C to convert excel spreadsheet into mysql Barry Schwarz <schwarzb@dqel.com> - 2016-12-09 08:53 -0800
          Re: Using C to convert excel spreadsheet into mysql Alla _ <modelling.data@gmail.com> - 2016-12-09 09:20 -0800
      Re: Using C to convert excel spreadsheet into mysql Keith Thompson <kst-u@mib.org> - 2016-12-09 11:05 -0800
        Re: Using C to convert excel spreadsheet into mysql Manfred <noname@invalid.add> - 2016-12-09 20:27 +0100
        Re: Using C to convert excel spreadsheet into mysql Alla _ <modelling.data@gmail.com> - 2016-12-11 03:19 -0800
          Re: Using C to convert excel spreadsheet into mysql Richard Heathfield <rjh@cpax.org.uk> - 2016-12-11 15:48 +0000
            Re: Using C to convert excel spreadsheet into mysql Keith Thompson <kst-u@mib.org> - 2016-12-11 12:32 -0800
            Re: Using C to convert excel spreadsheet into mysql Alla _ <modelling.data@gmail.com> - 2016-12-12 01:16 -0800
              Re: Using C to convert excel spreadsheet into mysql Richard Heathfield <rjh@cpax.org.uk> - 2016-12-12 10:31 +0000
                Re: Using C to convert excel spreadsheet into mysql Alla _ <modelling.data@gmail.com> - 2016-12-12 02:46 -0800
                  Re: Using C to convert excel spreadsheet into mysql Richard Heathfield <rjh@cpax.org.uk> - 2016-12-12 10:51 +0000
                  Re: Using C to convert excel spreadsheet into mysql Keith Thompson <kst-u@mib.org> - 2016-12-12 09:09 -0800
        Re: Using C to convert excel spreadsheet into mysql Alla _ <modelling.data@gmail.com> - 2016-12-11 03:31 -0800
        Re: Using C to convert excel spreadsheet into mysql Richard Heathfield <rjh@cpax.org.uk> - 2016-12-11 14:48 +0000
    Using C to convert excel spreadsheet into mysql "Rick C. Hodgin" <rick.c.hodgin@gmail.com> - 2016-12-09 03:16 -0800
      Re: Using C to convert excel spreadsheet into mysql Alla _ <modelling.data@gmail.com> - 2016-12-09 03:50 -0800
        Re: Using C to convert excel spreadsheet into mysql Richard Heathfield <rjh@cpax.org.uk> - 2016-12-09 12:00 +0000
          Re: Using C to convert excel spreadsheet into mysql Alla _ <modelling.data@gmail.com> - 2016-12-09 06:47 -0800
          Re: Using C to convert excel spreadsheet into mysql "Rick C. Hodgin" <rick.c.hodgin@gmail.com> - 2016-12-09 07:48 -0800
            Re: Using C to convert excel spreadsheet into mysql Richard Heathfield <rjh@cpax.org.uk> - 2016-12-09 16:17 +0000
            Re: Using C to convert excel spreadsheet into mysql Alla _ <modelling.data@gmail.com> - 2016-12-09 08:37 -0800
            Re: Using C to convert excel spreadsheet into mysql Alla _ <modelling.data@gmail.com> - 2016-12-09 08:45 -0800
              Re: Using C to convert excel spreadsheet into mysql "Rick C. Hodgin" <rick.c.hodgin@gmail.com> - 2016-12-09 08:50 -0800
                Re: Using C to convert excel spreadsheet into mysql Richard Heathfield <rjh@cpax.org.uk> - 2016-12-09 16:55 +0000
                  Re: Using C to convert excel spreadsheet into mysql "James R. Kuyper" <jameskuyper@verizon.net> - 2016-12-09 12:28 -0500
                    Re: Using C to convert excel spreadsheet into mysql Richard Heathfield <rjh@cpax.org.uk> - 2016-12-09 18:10 +0000
    Re: Using C to convert excel spreadsheet into mysql "Mr. Man-wai Chang" <toylet.toylet@gmail.com> - 2016-12-09 19:48 +0800
    Re: Using C to convert excel spreadsheet into mysql Keith Thompson <kst-u@mib.org> - 2016-12-09 11:00 -0800
      Re: Using C to convert excel spreadsheet into mysql Alla _ <modelling.data@gmail.com> - 2016-12-11 03:03 -0800
    Re: Using C to convert excel spreadsheet into mysql andre <ahr@blabla.be> - 2016-12-10 10:43 +0100
      Re: Using C to convert excel spreadsheet into mysql Alla _ <modelling.data@gmail.com> - 2016-12-11 03:33 -0800

Page 4 of 4 — ← Prev page 1 2 3 [4]

#98562

On Friday, December 9, 2016 at 6:48:17 PM UTC+3, Rick C. Hodgin wrote:
> On Friday, December 9, 2016 at 7:00:18 AM UTC-5, Richard Heathfield wrote:
> > [Before I could respond to this message, I considered it necessary to 
> > remove my newsreader's filter on Rick C Hodgin, to give him the 
> > opportunity to respond to the following, should he so choose.]
> > 
> > On 09/12/16 11:50, Alla _ wrote:
> > > On Friday, December 9, 2016 at 2:17:04 PM UTC+3, Rick C. Hodgin wrote:
> > >> Save it as CSV file, and then parse it.
> > 
> > So far so good.
> > 
> > >> Microsoft exposes "Excel.Application" as an object you can instantiate
> > >> in C++.  You can then obtain interfaces to the various functions, but
> > >> it is really complex to get everything just right.
> > 
> > This is really bad advice. Alla is trying to learn C, not Excel or 
> > Visual C++. From what I can gather, the whole point of this exercise is 
> > to give Alla experience in C programming. Excel automation and Visual 
> > C++ libraries are, therefore, completely the wrong way to go.
> > 
> > >> If you want to do it, search for "Excel automation in C" and you
> > >> might find some hits.
> > >>
> > >> Much easier to do it in Visual Basic or Visual FoxPro.  Plenty of online
> > >> automation examples there.
> > 
> > And how, precisely, will that help Alla to learn more about C?
> > 
> > > Thank you!
> > 
> > Alla, that's a very polite response to a very ignorant "contribution". I 
> > commend you on your restraint.
> 
> Alla, it was not my intention to mislead you or cause you confusion.
> 
> I would like to suggest that if you need to do this in C, it might
> be worth creating a Visual Basic DLL which you can call from C to
> retrieve the information for you as you need it, as VB also allows
> very easy access to the Excel.application object and all of Excel's
> internal content.  You can create a small DLL that you use in C to
> call simple functions like:
> 
>     open_spreadsheet()
>     get_cell_type()
>     get_cell_character_data()
>     get_cell_integer_data()
>     get_cell_floating_point_data()
>     get_cell_date_data()
>     close_spreadsheet()
>     et cetera
> 
> By using this interface, you can still access and process your data
> from C, but you will be using the higher level mechanisms to access
> it directly from the raw spreadsheet, rather than through conversion
> to CSV.
> 
> You can also update Excel spreadsheets that way:
> 
>     set_cell_character_data()
>     set_cell_interger_data()
>     et cetera
> 
> ...and use it to compute values by populating cells with data and
> retrieving post-compute results, etc.
> 
> -----
> If you're interested in doing this let me know.  If not, then please
> accept my sincerest apologies for wasting your time with my very
> ignorant "contribution."
> 
Richard and Rick, I do appreciate great help and all comments I receive,
and I also will appreciate keeping me away from your lovely friendly ragging 
of each other; do as you please and anywhere you please, but without 
attracting me as a third party ) 

> Best regards,
> Rick C. Hodgin

[toc] | [prev] | [next] | [standalone]

#98564

On Friday, December 9, 2016 at 11:45:57 AM UTC-5, Alla _ wrote:
> On Friday, December 9, 2016 at 6:48:17 PM UTC+3, Rick C. Hodgin wrote:
> > On Friday, December 9, 2016 at 7:00:18 AM UTC-5, Richard Heathfield wrote:
> > > [Before I could respond to this message, I considered it necessary to 
> > > remove my newsreader's filter on Rick C Hodgin, to give him the 
> > > opportunity to respond to the following, should he so choose.]
> > > 
> > > On 09/12/16 11:50, Alla _ wrote:
> > > > On Friday, December 9, 2016 at 2:17:04 PM UTC+3, Rick C. Hodgin wrote:
> > > >> Save it as CSV file, and then parse it.
> > > 
> > > So far so good.
> > > 
> > > >> Microsoft exposes "Excel.Application" as an object you can instantiate
> > > >> in C++.  You can then obtain interfaces to the various functions, but
> > > >> it is really complex to get everything just right.
> > > 
> > > This is really bad advice. Alla is trying to learn C, not Excel or 
> > > Visual C++. From what I can gather, the whole point of this exercise is 
> > > to give Alla experience in C programming. Excel automation and Visual 
> > > C++ libraries are, therefore, completely the wrong way to go.
> > > 
> > > >> If you want to do it, search for "Excel automation in C" and you
> > > >> might find some hits.
> > > >>
> > > >> Much easier to do it in Visual Basic or Visual FoxPro.  Plenty of online
> > > >> automation examples there.
> > > 
> > > And how, precisely, will that help Alla to learn more about C?
> > > 
> > > > Thank you!
> > > 
> > > Alla, that's a very polite response to a very ignorant "contribution". I 
> > > commend you on your restraint.
> > 
> > Alla, it was not my intention to mislead you or cause you confusion.
> > 
> > I would like to suggest that if you need to do this in C, it might
> > be worth creating a Visual Basic DLL which you can call from C to
> > retrieve the information for you as you need it, as VB also allows
> > very easy access to the Excel.application object and all of Excel's
> > internal content.  You can create a small DLL that you use in C to
> > call simple functions like:
> > 
> >     open_spreadsheet()
> >     get_cell_type()
> >     get_cell_character_data()
> >     get_cell_integer_data()
> >     get_cell_floating_point_data()
> >     get_cell_date_data()
> >     close_spreadsheet()
> >     et cetera
> > 
> > By using this interface, you can still access and process your data
> > from C, but you will be using the higher level mechanisms to access
> > it directly from the raw spreadsheet, rather than through conversion
> > to CSV.
> > 
> > You can also update Excel spreadsheets that way:
> > 
> >     set_cell_character_data()
> >     set_cell_interger_data()
> >     et cetera
> > 
> > ...and use it to compute values by populating cells with data and
> > retrieving post-compute results, etc.
> > 
> > -----
> > If you're interested in doing this let me know.  If not, then please
> > accept my sincerest apologies for wasting your time with my very
> > ignorant "contribution."
> > 
> Richard and Rick, I do appreciate great help and all comments I receive,
> and I also will appreciate keeping me away from your lovely friendly ragging 
> of each other; do as you please and anywhere you please, but without 
> attracting me as a third party ) 

Alla, where have I been negative toward Richard?  I would like to
apologize for where I have done this, if indeed I have.  I agree
with you completely about not dipping into negativity, but always
focusing upon the positive and uplifting.

Best regards,
Rick C. Hodgin

[toc] | [prev] | [next] | [standalone]

#98567

On 09/12/16 16:50, Rick C. Hodgin wrote:
> On Friday, December 9, 2016 at 11:45:57 AM UTC-5, Alla _ wrote:

<snip>

>> Richard and Rick, I do appreciate great help and all comments I receive,
>> and I also will appreciate keeping me away from your lovely friendly ragging
>> of each other; do as you please and anywhere you please, but without
>> attracting me as a third party )
>
> Alla, where have I been negative toward Richard?

You haven't. And I hope I haven't been negative towards you personally. 
I think your advice was terrible, of course, and I said so, in my usual 
somewhat strident manner --- but I would hope that, if ever *I* gave 
terrible advice, *you* would say so. (Someone has to, after all.)

-- 
Richard Heathfield
Email: rjh at cpax dot org dot uk
"Usenet is a strange place" - dmr 29 July 1999
Sig line 4 vacant - apply within

[toc] | [prev] | [next] | [standalone]

#98575

On 12/09/2016 11:55 AM, Richard Heathfield wrote:
...
> somewhat strident manner --- but I would hope that, if ever *I* gave
> terrible advice, *you* would say so. (Someone has to, after all.)

Frankly, I can't imagine that there would be any shortage of people 
willing to point it out.

[toc] | [prev] | [next] | [standalone]

#98585

On 09/12/16 17:28, James R. Kuyper wrote:
> On 12/09/2016 11:55 AM, Richard Heathfield wrote:
> ...
>> somewhat strident manner --- but I would hope that, if ever *I* gave
>> terrible advice, *you* would say so. (Someone has to, after all.)
>
> Frankly, I can't imagine that there would be any shortage of people
> willing to point it out.

That's what I love about comp.lang.c. :-)

-- 
Richard Heathfield
Email: rjh at cpax dot org dot uk
"Usenet is a strange place" - dmr 29 July 1999
Sig line 4 vacant - apply within

[toc] | [prev] | [next] | [standalone]

#98480

On 9/12/2016 6:50 PM, Alla _ wrote:
> Hello!
>
> I will be grateful for your help on this matter: I have searched google, and have found numerous
> suggestions how to convert excel spreadsheet into mysql table with php, but I need to do this
> using C. Please, without providing the ready solution, let me know if it is at all possible using
> reasonably basic tools appropriate for a student? If yes, I will continue the search, and will
> be grateful for tips on this issue (but, please, do not write a code for me; please).

You can make Excel connect directly to MySQL via ODBC driver?

[toc] | [prev] | [next] | [standalone]

#98596

Alla _ <modelling.data@gmail.com> writes:
> I will be grateful for your help on this matter: I have searched
> google, and have found numerous suggestions how to convert excel
> spreadsheet into mysql table with php, but I need to do this using
> C. Please, without providing the ready solution, let me know if it is
> at all possible using reasonably basic tools appropriate for a
> student? If yes, I will continue the search, and will be grateful for
> tips on this issue (but, please, do not write a code for me; please).

There are a number of different data formats at play here.

Microsoft Excel uses its own format for spreadsheet files; such files
typically have a ".xls" extension.  That format is tremendously
complex, and though it would be theoretically possible to parse
and process it in pure C, it would be neither feasible nor, most
likely, useful.  (The developers of OpenOffice and LibreOffice
have probably done something like that, but it must have been a
lot of work.)  There are other binary formats such as ".ods".

Excel can also export a spreadsheet in ".csv" (comma separated
values) format.  That's a plain-text format holding one record per
line, with fields within a record separated by commas.  It's not
quite that simple; there have to be special rules for fields that
contain commas, and there doesn't seem to be a single universally
accepted standard.  It can lose some of the information that exists
in the .xls format, but the information it retains is often all
you need.

Excel can *read* either a ".xls" or a ".csv" file and display
its contents for you -- but what it displays is a summary of the
contents, not the raw contents of the file.  For example, if you
load a ".csv" file, Excel won't show you the commas.  To see what's
actually in a ".csv" file, use a text editor or pager, some tool that
operates on text in general and not on spreadsheets in particular.

A MySQL database also is generally stored in a complex binary format.

Converting an Excel spreadsheet to a MySQL database without using
any external libraries is an entirely unreasonable task.

Converting a ".csv" file to a sequence of SQL commands that can
then be used to *create* a MySQL database is quite reasonable.
Excel can generate the ".csv" file for you, and MySQL can execute
the SQL commands and create a database.

-- 
Keith Thompson (The_Other_Keith) kst-u@mib.org  <http://www.ghoti.net/~kst>
Working, but not speaking, for JetHead Development, Inc.
"We must do something.  This is something.  Therefore, we must do this."
    -- Antony Jay and Jonathan Lynn, "Yes Minister"

[toc] | [prev] | [next] | [standalone]

#98776

<snip>
> Converting a ".csv" file to a sequence of SQL commands that can
> then be used to *create* a MySQL database is quite reasonable.
> Excel can generate the ".csv" file for you, and MySQL can execute
> the SQL commands and create a database.
> 
Thank you very much. I came up with an idea of converting Excel files 
directly into MySQL table because I have already done exercises with parsing
and processing data from MySQL tables, though in php; but I have 
also seen reasonably clear examples of how to do that with C.
Now I know that I can't skip .csv stage, therefore it doesn't make
any sense now to proceed with the whole MySQL issue, and just 
process data from csv files. 

[toc] | [prev] | [next] | [standalone]

#98674

Le 09/12/2016 11:50, Alla _ a écrit :
> Hello!
>
> I will be grateful for your help on this matter: I have searched google, and have found numerous
> suggestions how to convert excel spreadsheet into mysql table with php, but I need to do this
> using C. Please, without providing the ready solution, let me know if it is at all possible using
> reasonably basic tools appropriate for a student? If yes, I will continue the search, and will
> be grateful for tips on this issue (but, please, do not write a code for me; please).
>
> Thank you very much!
>
Could ODBC be a solution for you??
André

-- 
Les politiciens sont imprévoyants, et les électeurs sans mémoire!

[toc] | [prev] | [next] | [standalone]

#98779

On Saturday, December 10, 2016 at 12:43:17 PM UTC+3, andre wrote:
> Le 09/12/2016 11:50, Alla _ a écrit :
> > Hello!
> >
> > I will be grateful for your help on this matter: I have searched google, and have found numerous
> > suggestions how to convert excel spreadsheet into mysql table with php, but I need to do this
> > using C. Please, without providing the ready solution, let me know if it is at all possible using
> > reasonably basic tools appropriate for a student? If yes, I will continue the search, and will
> > be grateful for tips on this issue (but, please, do not write a code for me; please).
> >
> > Thank you very much!
> >
> Could ODBC be a solution for you??
Maybe, but I am not ready to learn new programs now. My goal is to write a C code. 
But thank you for your suggestion.
> André
> 
> -- 
> Les politiciens sont imprévoyants, et les électeurs sans mémoire!

[toc] | [prev] | [standalone]

Page 4 of 4 — ← Prev page 1 2 3 [4]

Back to top | Article view | comp.lang.c

csiph-web