Search found 3 matches

by axel
Tue Jan 13, 2009 5:39 pm
Forum: XLSReadWriteII 3/4/5
Topic: Delete sheet corrupts file
Replies: 0
Views: 2303

Delete sheet corrupts file

Hello, I have an Excel file of 60 sheets. Sheets are very similar - just few cells differs them from each other. I can delete some of them, but deleting most of them causes written file to be corrupted. There is a binary image on sheet is it counts... What I'm going to gain with this is copying ever...
by axel
Fri Jan 09, 2009 8:27 pm
Forum: XLSReadWriteII 3/4/5
Topic: tcopycelloptions definition
Replies: 1
Views: 2400

Re: tcopycelloptions definition

Ok. It was XLSUtils4.dcu.

Got it to work...
by axel
Fri Jan 09, 2009 1:32 pm
Forum: XLSReadWriteII 3/4/5
Topic: tcopycelloptions definition
Replies: 1
Views: 2400

tcopycelloptions definition

Hello, I need to perform a simple task: remove all formulas on sheet but keeping values. The simplest way to do this in Excel is Select All, copy, copy special and only values. I think this could work just fine in XLSReadWrite but I'm facing a problem: TCopyCellOptions is not defined. XLS.CopyCells(...