hi ,
 in spreadsheet,  
invoke SendMessage,hSpr,SPRM_IMPORTLINE,';',offset szDataLine                  ;can import batch data to row cell.

I want import the batch data to col cell. what can I do?
Posted on 2005-08-29 05:03:17 by gt2000

You can't use SPRM_IMPORTLINE.
It muste be done the hard way (see example).

Posted on 2005-08-29 07:05:49 by KetilO
nice,thanks. 8)

and help me how can i change the cell' width of the serial number's cell.
Posted on 2005-08-30 11:48:12 by gt2000

Are you asking about setting the column width / height or expanding a cell to cover more than one cell?

Posted on 2005-08-31 05:07:21 by KetilO
I only want to change one col' width. see the pucture.
Posted on 2005-08-31 07:53:57 by gt2000
Use the SPRM_SETCOLWIDTH message on column 0.

invoke SendMessage,hSht,SPRM_SETCOLWIDTH,0,100

Posted on 2005-08-31 09:24:30 by KetilO
it's so easy that it's here. :shock:
Posted on 2005-08-31 11:12:22 by gt2000
Hi KetilO,
    I want saved the spreadsheet's cells to excel's Documents,but don't found conversion function spreadsheet's api in spreadsheet.inc.
How should I do? :sad:
Posted on 2005-10-03 14:01:38 by gt2000
Hi gt2000

You have to write the converter yourself. If you do, would you be kind and share it with the rest of us?

Posted on 2005-10-03 14:48:13 by KetilO
trouble!! :sad:
Posted on 2005-10-16 13:09:19 by gt2000

Go to:


and click on the


link on the left side of the screen.  There you will find on page 1, a link to CSV file format info and on page 2 you will find a link for XLS file format info.  The CSV format would probably be easier to use.  Show us your work on converting the data!

Posted on 2005-10-16 17:16:07 by farrier
Thanks farrier, Good idea.
Posted on 2005-10-17 02:55:11 by gt2000
Hi KetilO,
    help me,the spreadsheet's memory, The MEMMAX=4*1024*1024,in every sheet,but my sheet's used memory is prodigiouss different.
  I want used different size memory, How can used different size memory in different sheet?
Posted on 2005-11-20 09:35:39 by gt2000
Dynamic memory allocation is currently not supported.

Posted on 2005-11-24 16:04:07 by KetilO
Posted on 2005-11-26 11:23:50 by gt2000
hello, KetilO, The file "include ..\SpreadSheet.inc" is not in the package.


You can't use SPRM_IMPORTLINE.
It muste be done the hard way (see example).

Posted on 2005-11-27 21:55:12 by miaomiao