2. ASPRunnerPro General questions
  3. Export to Ms Excel
This topic is locked

Export to Ms Excel

 		5/16/2004 2:54:20 AM
ASPRunnerPro General questions
A
 awl author

I've one more problem regarding the digits after coma matter. Data are exported to Excel in wrong way. E.g. the number 9500,88 (on the web page) in Ms Excel looks like this 950 088 399 999 999 but in Ms Word looks like this 9500,88399999999. What can be cause of that?
kind regards,
Adam Wolf
Sergey Kornilov admin 5/19/2004

Adam,
I guess you can try the same method of setting number of digits after comma:

<%

Response.Write FormatNumber(GetData(rsData.Fields("SumazWartoscReorderLevel"), ""),2)
%>
500116 5/19/2004

Sergey,
I just made it as you advised in previous problem description regarding digits after coma. It appears in data modified with FormatNumber code.
regards,
Adam Wolf
Sergey Kornilov admin 5/20/2004

Adam,
Could you please zip and send to support AT xlinesoft.com the whole content of ASPRunner output folder with subfolders ( ASP files, include files, database etc.)along with project file? I'll find what's wrong running it on my test box.
Also tell me what version of MS Office do you use.
A
 		awl author 5/21/2004

Sergey,
I can send you ziped ASP output folder but database takes almost 500MB.

What to do in this case?
I use Office 2000 Premium.
regards,
Adam Wolf
Sergey Kornilov admin 5/21/2004

Adam,
I don't need all your data. Several data records will be enough to reproduce a problem.