Hi David,

If you can tell me what formatting you need to do, I can perhaps help 
out.

Generally, excelobject.cells.numberformat = "#########.0000" or 
excelobject.columns(i).numberformat = "#########.00"

instead of numberformat, you can use other formatting options provided 
by VBA Excel too.

Hope that helps.
Cheers,
Vidya.

On Thu, 25 Jul 2002 21:17:06 -0700
  rebmanda@W... wrote:
>DO you know how to format the contents of the Excel spreadsheet?
>
>Thank you,
>
>David Rebman
>
>
>
>-----Original Message-----
>From: Sri Vidya [mailto:svsvidya@i...]
>Sent: Thursday, July 25, 2002 9:03 PM
>To: aspx_beginners
>Subject: [aspx_beginners] Re: How to write into Excel spreadsheet
>
>
>Hi Sergiy,
>
>      You can write data into Excel Spreadsheet by Instantiating the 
>Excel Object. Use CreateObject function to create a new excel 
>spreadsheet for the first time. From then on, just open the created 
>worksheet, add new lines to it and save it using the excel object's 
>save function.
>
>
>You will have to handle the following errors:
>1. Successful creation of the Excel Object.
>2. Error saving the file.
>3. Error opening the file.
>
>Hope this helps. otherwise, if you can give me the description of the 
>problem, I could furnish more details.
>
>Cheers,
>Vidya.
>
>On Thu, 25 Jul 2002 14:40:38 +1200
>   "Sergiy" <sergiy@x...> wrote:
>>Hi,
>>
>>can anyone tell me how to write data into Excel spreadsheet? (just 
>>adding each time new lines to it)
>>
>>Sergiy
>>
>>
>>
>
>---------------------------------------------
>http://mail.indiainfo.com
>India's first ISO certified portal
>Check world time at http://time.indiainfo.com
>
>

---------------------------------------------
http://mail.indiainfo.com
India's first ISO certified portal
Check world time at http://time.indiainfo.com