Search found 4 matches

by David
Wed Jul 12, 2017 11:10 am
Forum: XLSReadWritwII 6
Topic: Error openinng xls files.
Replies: 3
Views: 2259

Re: Error openinng xls files.

Hi I have now debugged through the code using the source files instead of the complied code fields and found out where I am receiving the "Missing Password" error. Although I set the version of Excel upfront before calling the Read procedure, within the TXLSReadWriteII5.LoadFromFile proced...
by David
Tue Jul 11, 2017 1:17 pm
Forum: XLSReadWritwII 6
Topic: Error openinng xls files.
Replies: 3
Views: 2259

Re: Error openinng xls files.

Hi I am receiving the same error when trying to open xls files: "Missing Password". I have tried both: XLSReader := TXLSReadWriteII5.Create(nil); XLSReader.Filename := 'file.xls'; XLSReader.Version := xvExcel97; XLSReader.Read; and XLSReader := TXLSReadWriteII5.Create(nil); XLSReader.Versi...
by David
Mon Jul 10, 2017 1:53 pm
Forum: XLSReadWritwII 6
Topic: FontColor issue on Cell
Replies: 0
Views: 1774

FontColor issue on Cell

Hi There seems to be an issue when trying to set FontColor to via RGB. If i am setting the version to xvExcel97 and setting the FontColor to RGB(255, 102, 0) it sets it to Orange as expected. If i set the version to xvExcel2007 and then set the FontColor to RGB(255, 102, 0) it shows as a shade of bl...
by David
Wed Mar 02, 2011 7:07 am
Forum: XLSReadWriteII 3/4/5
Topic: How to Create and apply a cell format setting
Replies: 1
Views: 3150

How to Create and apply a cell format setting

Hi We have recently upgraded from ReadWriteII to ReadWriteII 4. We are struggling to get our old format settings recreated after changing to the newer version. We used to create a list of formats which we would then assign when writing out the cells of the spreadsheet we are creating. So we create o...