|
| EXCEL file generated from webdev is different |
| Iniciado por guest, 05,feb. 2015 12:07 - 4 respuestas |
| |
| | | |
|
| |
| Publicado el 05,febrero 2015 - 12:07 |
Hi,
My client send me sample xls file ( from their old system ) that they need to be imported..
when i open the file in NOTEPAD, i can see the following
<html xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="<a class="ExternalLink" rel="nofollow" target="_blank" href="http://www.w3.org/TR/REC-html40">http://www.w3.org/TR/REC-html40</a>">
<head>
<meta http-equiv=Content-Type content="text/html; charset=utf-8">
<meta name=ProgId content=Excel.Sheet>
<!--[if gte mso 9]><xml>
<o:DocumentProperties>
<o:LastAuthor>Sriram</o:LastAuthor>
<o:LastSaved>2005-01-02T07:46:23Z</o:LastSaved>
<o:Version>10.2625</o:Version>
</o:DocumentProperties>
<o:OfficeDocumentSettings>
<o:DownloadComponents/>
</o:OfficeDocumentSettings>
</xml><![endif]-->
the info in this file is different from the xls file generated by webdev..Does anybody know of any solution ?
Regards,
PETER ZHOU |
| |
| |
| | | |
|
| | |
| |
| Publicado el 05,febrero 2015 - 12:42 |
Peter the text you post isn't in xls or xlsx format.
It look like it's in html format, it's probably one excel file but they use save as html.
just create one xls or xlsx file with excel and open it with notepad you will se the diference, after this use excel save as and choose html format.
If this is true you will have some dificulties to do this kind of files in webdev normally the servers don't have excel installed. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 05,febrero 2015 - 13:20 |
Quote
Paulo Oliveira
Peter the text you post isn't in xls or xlsx format.
It look like it's in html format, it's probably one excel file but they use save as html.
just create one xls or xlsx file with excel and open it with notepad you will se the diference, after this use excel save as and choose html format.
If this is true you will have some dificulties to do this kind of files in webdev normally the servers don't have excel installed.
Yes..i have noticed the difference between XLS file generated by webdev.
If the webdev's server has excel installed, how can webdev ( using coding and not a manual process) to convert to the file format that they need ? |
| |
| |
| | | |
|
| | |
| |
| Publicado el 05,febrero 2015 - 13:28 |
I never done it with webdev but probably you can do it the same way as in windev using Automation object
If you have windev check the example in \Examples\Training\WD Controlling Excel |
| |
| |
| | | |
|
| | |
| |
| Publicado el 05,febrero 2015 - 14:26 |
Hi
trying to use OLE automation on a web server is a VERY BAD idea... In fact, even Microsoft says that it WILL crash your server as soon as you have enough queries at the same time
On another hand, it's quite easy to use gembox.net to manage office documents. It is also much faster and uses way less resources, and office doesn't have to be installed
Best regards |
| |
| |
| | | |
|
| | | | |
| | |
|