Axolot Data

Dear all, We are using XLSDbRead5 linked with XLSReadWriteII5 components to extract some of our SQLServer data to an xlsx file. It's working great so far. Some of our customers got some strange non printing caracters (like ASCII #31 for example) in some varchar fields. It can comes from copy/past fr...

Dear Larsa,

It's working great,

Thanks for your answer.

Noémie

For those who might be insterrested. I solved my problem with this function :
Cheers

Noémie

Dear all, I try to set the string value of a cell on multiple lines. For this I use "#13+#10" caractères (CR/LF) This way : XLSReadWriteII51[0].AsString[Col,Row]:='TEST'+#13+#10+'TEST 2'; XLSReadWriteII51[0].Rows[Row].Height:=4000; When I open the xlsx file, the data are in one line "...

Dear cakmakb,

I got the exact same problem as you. Did you find any solution to change the font of only one cell?

Thanks a lot.

Noémie

Hi everybody, We are using TXLSReadWriteII5 component to extract data to xlsx universal format. I got a problem with the "ShrinkToFit" procedure for a column property. This returns an exception and wont work. I use it successfully with a row. Here is a mini-sample where I reproduced the er...

Hi guys, I would like to know if it's possible to copy some rows from a TXLSSpreadSheet to another TXLSSpreadSheet and to keep the same format (row height, cells font, cells colors, Pictures, ...) For the project I am now developping, I actually need to concatenate several XLS file in only one on th...

Hi. I have an XLSX file which contains several sheets (About 15) Is there a way to load only one sheet in the XLSSpreadSheet component with the "read" method (By specifying the sheet number for example)? My XLSX file is quite big and it takes a long time to read the whole file. As I only n...