Reading Excel and displaying the data using Glenn's XlLib UDFs - KiXtart.org - official site

You are not logged in. [Log In] KiXtart.org website » Forums » KiXtart » Advanced Scripting » Reading Excel and displaying the data using Glenn's XlLib UDFs

Page 1 of 1

1

Topic Options

#204325 - 2012-02-21 02:20 PM Reading Excel and displaying the data using Glenn's XlLib UDFs
Mart Mart KiX Supporter Registered: 2002-03-27 Posts: 4673 Loc: The Netherlands	I have an issue that I just cannot get resolved. Maybe I'm just missing something but I've been staring at this and trying several things this morning and it is just not doing what I want it to do. I'm using Glenn's XlLib functions to read training data from excel and have it create a list of followed trainings for each of our employees. The Excel file contains column names in the first row and then x rows of data. Each row represents one training and has six columns with data like training name, start date, end date, etc.... Up until now I’m not able to get the data displayed after reading the Excel file. Any help would be appreciated. Below is a small example of how I’m reading the data from Excel but I cannot seem to figure out a way to display it without getting “Array out of bounds….”, “This type of array is not supported…”, etc… Code: $oXLS = xlInit() $XLSFile = xlFile($oXLS, "Open", "d:\testfile.xlsx") $val = xlRangeValue($oXLS, 'A2:F3') $rc = xlQuit($oExcel) My test excel file look like this. Code: A B C D E F 1 name start end where who certificate 2 name1 start1 end1 where1 who1 certificate1 _________________________ Mart - Chuck Norris once sold ebay to ebay on ebay.
Top

#204326 - 2012-02-21 03:33 PM Re: Reading Excel and displaying the data using Glenn's XlLib UDFs [Re: Mart]
Allen Allen KiX Supporter Registered: 2003-04-19 Posts: 4557 Loc: USA	Maybe this will help? http://www.kixtart.org/forums/ubbthreads.php?ubb=showflat&Number=180996#Post180996
Top

#204327 - 2012-02-21 05:16 PM Re: Reading Excel and displaying the data using Glenn's XlLib UDFs [Re: Allen]
Mart Mart KiX Supporter Registered: 2002-03-27 Posts: 4673 Loc: The Netherlands	Hmmmmm....looked at that post and somehow missed part of it. Actually this is to be expected if you have been testing trying, crashing and burning, trying again, etc… for several hours. I got something cooking now. Will post back later once it is all cooked and ready. Thanks Allen. _________________________ Mart - Chuck Norris once sold ebay to ebay on ebay.
Top

Page 1 of 1

1

Previous Topic

Previous Topic View All Topics

View All Topics

Index Next Topic

Next Topic

Moderator: Glenn Barnas, NTDOC, Arend_, Jochen, Radimus, Allen, ShaneEP, Ruud van Velsen, Mart

Hop to:

Shout Box

Who's Online

0 registered and 323 anonymous users online.

Newest Members

Audio, Hoschi, Comet, rrosell, PatrickPinto
17880 Registered Users

Generated in 0.125 seconds in which 0.101 seconds were spent on a total of 13 queries. Zlib compression enabled.

click tracking