missing leading zero when we download in excel from html table data.
missing leading zero when we download in excel from html table data.
(OP)
Hi Friends,
when i am downloading html table data into excel actually leading zero's are missing, could some one help on this.
Below is the code snippet.
htp.print( '<div style="width:100%; height:440px; overflow:auto;">');
htp.print('<TABLE ALIGN=CENTER BORDER=1 height=200px overflow=scroll CELLPADDING=0 CELLSPACING=0 WIDTH=150% style="border-collapse: collapse;">');
htp.print('<TR ALIGN=CENTER BGCOLOR=LIGHTBLUE>');
htp.print('<TD colspan="1" scope="colgroup" BGCOLOR="FFCC99"><B> Job No </B></TD >');
htp.print('</TR>');
Thanks
Ashok Kumar Y.
when i am downloading html table data into excel actually leading zero's are missing, could some one help on this.
Below is the code snippet.
htp.print( '<div style="width:100%; height:440px; overflow:auto;">');
htp.print('<TABLE ALIGN=CENTER BORDER=1 height=200px overflow=scroll CELLPADDING=0 CELLSPACING=0 WIDTH=150% style="border-collapse: collapse;">');
htp.print('<TR ALIGN=CENTER BGCOLOR=LIGHTBLUE>');
htp.print('<TD colspan="1" scope="colgroup" BGCOLOR="FFCC99"><B> Job No </B></TD >');
htp.print('</TR>');
Thanks
Ashok Kumar Y.
RE: missing leading zero when we download in excel from html table data.
You're at the mercy of Excel's automatic handling of HTML. You could alternatively look at having the web server deliver an Excel file.