Dear all, I did not manage to get the perl codes running properly, but then again, I did not invest too much time in it and I am not familiar with perl.
I did come across a xls2csv executable, which runs smoothly under cygwin and can be easily lined up with (g)awk and sed to get to what I wanted. Thanks for your suggestions ! With best regards / Vennlig hilsen Maarten On Fri, Feb 5, 2010 at 12:59 PM, Ehud Karni <e...@unix.mvs.co.il> wrote: > On Thu, 4 Feb 2010 19:55:36 Maarten Vanneste wrote: >> >> Dear all, >> I was wondering whether there is a cygwin tool/program which converts >> microsoft excel files to text. Any suggestions ? > > I use xlhtml, source at: http://chicago.sourceforge.net/xlhtml/ > > I applied the following patch: > > diff -c ~/xlhtml-0.5/xlhtml/xlhtml.h-org ~/xlhtml-0.5/xlhtml/xlhtml.h > *** ~/xlhtml-0.5/xlhtml/xlhtml.h-org Thu Apr 11 03:23:51 2002 > --- ~/xlhtml-0.5/xlhtml/xlhtml.h Thu Dec 24 18:16:51 2009 > *************** > *** 20,28 **** > #include "version.h" > > /* Used by packed string array Opcode: 0xFC */ > ! #define HARD_MAX_ROWS_97 0x7FFE /*!< Used in add_wb_array to > prevent OOM */ > ! #define HARD_MAX_ROWS_95 0x3FFF /*!< Used in add_wb_array to > prevent OOM */ > ! #define HARD_MAX_COLS 256 /*!< Used in add_wb_array to > prevent OOM */ > > static U16 HARD_MAX_ROWS = HARD_MAX_ROWS_97; > /********************************** > --- 20,28 ---- > #include "version.h" > > /* Used by packed string array Opcode: 0xFC */ > ! #define HARD_MAX_ROWS_97 0x0FFFF /*!< Used in add_wb_array to > prevent OOM */ > ! #define HARD_MAX_ROWS_95 0x07FFF /*!< Used in add_wb_array to > prevent OOM */ > ! #define HARD_MAX_COLS 256 /*!< Used in add_wb_array to > prevent OOM */ > > static U16 HARD_MAX_ROWS = HARD_MAX_ROWS_97; > /********************************** > *************** > *** 57,63 **** > U16 type; /*!< This will record the record type that generated > the cell */ > U16 spanned; /*!< If 1 don't output */ > uni_string ustr; /*!< The cell's displayed contents */ > ! U16 rowspan; /*!< rows to span */ > U16 colspan; /*!< columns to span */ > uni_string h_link; /*!< If a hyperlinked cell, this is the link*/ > }cell; > --- 57,63 ---- > U16 type; /*!< This will record the record type that generated > the cell */ > U16 spanned; /*!< If 1 don't output */ > uni_string ustr; /*!< The cell's displayed contents */ > ! U32 rowspan; /*!< rows to span */ > U16 colspan; /*!< columns to span */ > uni_string h_link; /*!< If a hyperlinked cell, this is the link*/ > }cell; > > > I did it on GNU/Linux but I think it'll work well on Cygwin. > > It worked for several years in our company without the patch, but > lately we started receiving Excel files with 65535 lines in one sheet, > so I had to change the hard coded line limit. > > Ehud. > > > -- > Ehud Karni Tel: +972-3-7966-561 /"\ > Mivtach - Simon Fax: +972-3-7976-561 \ / ASCII Ribbon Campaign > Insurance agencies (USA) voice mail and X Against HTML Mail > http://www.mvs.co.il FAX: 1-815-5509341 / \ > GnuPG: 98EA398D <http://www.keyserver.net/> Better Safe Than Sorry > -- Problem reports: http://cygwin.com/problems.html FAQ: http://cygwin.com/faq/ Documentation: http://cygwin.com/docs.html Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
