Hi Ishen
Here a example how you can convert a column from to date/text or numeric.
(for other conversions, create a macro in excel and see inside the macro how
to convert)
xl := CreateOleObject('Excel.Application');
xl.Visible := True;
XL.Workbooks.Add(xlWorkSheet);
XL.Workbooks[1].WorkSheets[1].Name := order + '_' + datetostr(date);
sheet := XL.Workbooks[1].WorkSheets[order + '_' + datetostr(date)];
sheet.columns[13].NumberFormat := 'd-m-yyyy'; // date
sheet.columns[14].NumberFormat := '@'; // text
sheet.Columns[15].NumberFormat := '0,00'; // number
Greetings
Edwin
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf
Of Ishen Seocharan
Sent: woensdag 7 december 2005 7:21
To: [email protected]
Subject: [delphi-en] Excel Help!
Hi All,
I am working with Delphi 5,6,7 and trying to find some source code that
allows me to read an Excel worksheet and convert a column from text to
numeric.
There is a manual process in Excel which requires you to go to each cell
(not fun when it involves thousands of cells) but I want to select a
column and convert.
Anyone has any source code for me.
Thanks in advance.
Regards,
Ishen Seocharan
--
This e-mail and its contents are subject to the
South African Medical Research Council
e-mail legal notice available at
http://www.mrc.ac.za/about/EmailLegalNotice.htm
[Non-text portions of this message have been removed]
-----------------------------------------------------
Home page: http://groups.yahoo.com/group/delphi-en/
To unsubscribe: [EMAIL PROTECTED]
Yahoo! Groups Links
------------------------ Yahoo! Groups Sponsor --------------------~-->
Most low income households are not online. Help bridge the digital divide today!
http://us.click.yahoo.com/I258zB/QnQLAA/TtwFAA/i7folB/TM
--------------------------------------------------------------------~->
-----------------------------------------------------
Home page: http://groups.yahoo.com/group/delphi-en/
To unsubscribe: [EMAIL PROTECTED]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/delphi-en/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
