Microsoft bug in excel.Please suggest a work around !!

  • Thread starter Thread starter only2gayathri
  • Start date Start date
O

only2gayathri

Hi all,

I have a page(vb.net) which directs to a excel sheet.This excel sheet
retains all the values(mainly numbers) from the page and displays
it.The problem is that sometimes the number's remain in text format
when downloaded to excel and this kind of creates a flag(similar to
the one when we add comments in the excel)in some of the cells.This
problem occurs only sometimes.
Can anyone suggest anyway of overcoming these??Like using a number
formatter(or x:num)

Please suggest a work around for this.

Thanks,
Kushi
 
How are you outputting the data? Are you using Ado.net or using com
interop and "hijacking" the excel document. If the latter, look up the
NumberFormat method in the excel 11.0 object library. If you're using
ADO.Net than I can't think of a solution off hand.

Thanks,

Seth Rowe
 
I am using ado.net.Its basically a web based application.Can anyone
please suggest me if there is any solution to the problem??
 
Back
Top