one more format for excel

General Help regarding HMG, Compilation, Linking, Samples

Moderator: Rathinagiri

Post Reply
User avatar
dragancesu
Posts: 930
Joined: Mon Jun 24, 2013 11:53 am
DBs Used: DBF, MySQL, Oracle
Location: Subotica, Serbia

one more format for excel

Post by dragancesu »

I needed to transfer data from the database to excel format, I used a tool and was a little surprised by the result, more precisely by the output format, the result is in the attachment
Attachments
excel.zip
(1021 Bytes) Downloaded 161 times
Top
edk
Posts: 999
Joined: Thu Oct 16, 2014 11:35 am
Location: Poland

Re: one more format for excel

Post by edk »

The file you attached is not saved in xls or xlsx format, but in html. :!:

Code: Select all

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40"
 dir=LTR>
<head>
<meta http-equiv="Content-Type"  content="text/html; charset=WINDOWS-1250">

<title>76dpJu66</title>
<!--[if gte mso 9]><xml>
<o:DocumentProperties>
<o:Author>Oracle Reports</o:Author>
<o:Company>Oracle Corporation</o:Company>
<o:Created>2023-10-25 10-40-52</o:Created></o:DocumentProperties>
<o:OfficeDocumentSettings>
<o:AllowPNG/>
<o:DownloadComponents/>
<o:DoNotOrganizeInFolder/>
</o:OfficeDocumentSettings>
</xml><![endif]-->
<!--[if gte mso 9]><xml>
<x:ExcelWorkbook>
<x:ExcelWorksheets>
<x:ExcelWorksheet>
<x:Name>Sheet1</x:Name>
<x:WorksheetOptions>
<x:FitToPage/>
<x:ProtectContents>False</x:ProtectContents>
<x:ProtectContents>False</x:ProtectContents>
</x:WorksheetOptions>
</x:ExcelWorksheet>
</x:ExcelWorksheets>
<x:ProtectStructure>False</x:ProtectStructure>
<x:ProtectWindows>False</x:ProtectWindows>
</x:ExcelWorkbook>
</xml><![endif]-->
</head>
<body bgcolor="#ffffff">
<TABLE border="0" cellspacing="0" width="100%">
<TR>
<TD ALIGN="left" DIR="LTR"><SPAN STYLE="FONT-SIZE: 7pt; FONT-FAMILY: Arial; COLOR: #000000; FONT-STYLE: normal; FONT-WEIGHT: 400">Sifpodmag</SPAN></TD>
<TD ALIGN="left" DIR="LTR"><SPAN STYLE="FONT-SIZE: 7pt; FONT-FAMILY: Arial; COLOR: #000000; FONT-STYLE: normal; FONT-WEIGHT: 400">Sifmag</SPAN></TD>
<TD ALIGN="left" DIR="LTR"><SPAN STYLE="FONT-SIZE: 7pt; FONT-FAMILY: Arial; COLOR: #000000; FONT-STYLE: normal; FONT-WEIGHT: 400">Sif Per</SPAN></TD>
<TD ALIGN="left" DIR="LTR"><SPAN STYLE="FONT-SIZE: 7pt; FONT-FAMILY: Arial; COLOR: #000000; FONT-STYLE: normal; FONT-WEIGHT: 400">Tdok</SPAN></TD>
<TD ALIGN="left" DIR="LTR"><SPAN STYLE="FONT-SIZE: 7pt; FONT-FAMILY: Arial; COLOR: #000000; FONT-STYLE: normal; FONT-WEIGHT: 400">Bdok</SPAN></TD>
<TD ALIGN="left" DIR="LTR"><SPAN STYLE="FONT-SIZE: 7pt; FONT-FAMILY: Arial; COLOR: #000000; FONT-STYLE: normal; FONT-WEIGHT: 400">Rbr</SPAN></TD>
<TD ALIGN="left" DIR="LTR"><SPAN STYLE="FONT-SIZE: 7pt; FONT-FAMILY: Arial; COLOR: #000000; FONT-STYLE: normal; FONT-WEIGHT: 400">Sifart</SPAN></TD>
<TD ALIGN="left" DIR="LTR"><SPAN STYLE="FONT-SIZE: 7pt; FONT-FAMILY: Arial; COLOR: #000000; FONT-STYLE: normal; FONT-WEIGHT: 400">Naziv</SPAN></TD>
<TD ALIGN="left" DIR="LTR"><SPAN STYLE="FONT-SIZE: 7pt; FONT-FAMILY: Arial; COLOR: #000000; FONT-STYLE: normal; FONT-WEIGHT: 400">Ulaz</SPAN></TD>
<TD ALIGN="left" DIR="LTR"><SPAN STYLE="FONT-SIZE: 7pt; FONT-FAMILY: Arial; COLOR: #000000; FONT-STYLE: normal; FONT-WEIGHT: 400">Izlaz</SPAN></TD>
<TD ALIGN="left" DIR="LTR"><SPAN STYLE="FONT-SIZE: 7pt; FONT-FAMILY: Arial; COLOR: #000000; FONT-STYLE: normal; FONT-WEIGHT: 400">Cena</SPAN></TD>
<TD ALIGN="left" DIR="LTR"><SPAN STYLE="FONT-SIZE: 7pt; FONT-FAMILY: Arial; COLOR: #000000; FONT-STYLE: normal; FONT-WEIGHT: 400">Vu</SPAN></TD>
<TD ALIGN="left" DIR="LTR"><SPAN STYLE="FONT-SIZE: 7pt; FONT-FAMILY: Arial; COLOR: #000000; FONT-STYLE: normal; FONT-WEIGHT: 400">Vi</SPAN></TD>
<TD ALIGN="left" DIR="LTR"><SPAN STYLE="FONT-SIZE: 7pt; FONT-FAMILY: Arial; COLOR: #000000; FONT-STYLE: normal; FONT-WEIGHT: 400">Datum</SPAN></TD>
</TR>
<TR>
<TD ALIGN="left" DIR="LTR"><SPAN STYLE="FONT-SIZE: 7pt; FONT-FAMILY: Arial; COLOR: #000000; FONT-STYLE: normal; FONT-WEIGHT: 400">07</SPAN></TD>
<TD ALIGN="left" DIR="LTR"><SPAN STYLE="FONT-SIZE: 7pt; FONT-FAMILY: Arial; COLOR: #000000; FONT-STYLE: normal; FONT-WEIGHT: 400">0108</SPAN></TD>
<TD ALIGN="left" DIR="LTR"><SPAN STYLE="FONT-SIZE: 7pt; FONT-FAMILY: Arial; COLOR: #000000; FONT-STYLE: normal; FONT-WEIGHT: 400">16</SPAN></TD>
<TD ALIGN="left" DIR="LTR"><SPAN STYLE="FONT-SIZE: 7pt; FONT-FAMILY: Arial; COLOR: #000000; FONT-STYLE: normal; FONT-WEIGHT: 400">ID</SPAN></TD>
<TD ALIGN="left" DIR="LTR"><SPAN STYLE="FONT-SIZE: 7pt; FONT-FAMILY: Arial; COLOR: #000000; FONT-STYLE: normal; FONT-WEIGHT: 400">143</SPAN></TD>
<TD ALIGN="left" DIR="LTR"><SPAN STYLE="FONT-SIZE: 7pt; FONT-FAMILY: Arial; COLOR: #000000; FONT-STYLE: normal; FONT-WEIGHT: 400">1</SPAN></TD>
<TD ALIGN="left" DIR="LTR"><SPAN STYLE="FONT-SIZE: 7pt; FONT-FAMILY: Arial; COLOR: #000000; FONT-STYLE: normal; FONT-WEIGHT: 400"> 319772</SPAN></TD>
<TD ALIGN="left" DIR="LTR"><SPAN STYLE="FONT-SIZE: 7pt; FONT-FAMILY: Arial; COLOR: #000000; FONT-STYLE: normal; FONT-WEIGHT: 400">ODVIJAČ</SPAN></TD>
<TD ALIGN="left" DIR="LTR"><SPAN STYLE="FONT-SIZE: 7pt; FONT-FAMILY: Arial; COLOR: #000000; FONT-STYLE: normal; FONT-WEIGHT: 400">.00</SPAN></TD>
<TD ALIGN="left" DIR="LTR"><SPAN STYLE="FONT-SIZE: 7pt; FONT-FAMILY: Arial; COLOR: #000000; FONT-STYLE: normal; FONT-WEIGHT: 400">2.00</SPAN></TD>
<TD ALIGN="left" DIR="LTR"><SPAN STYLE="FONT-SIZE: 7pt; FONT-FAMILY: Arial; COLOR: #000000; FONT-STYLE: normal; FONT-WEIGHT: 400">4348.22</SPAN></TD>
<TD ALIGN="left" DIR="LTR"><SPAN STYLE="FONT-SIZE: 7pt; FONT-FAMILY: Arial; COLOR: #000000; FONT-STYLE: normal; FONT-WEIGHT: 400">.00</SPAN></TD>
<TD ALIGN="left" DIR="LTR"><SPAN STYLE="FONT-SIZE: 7pt; FONT-FAMILY: Arial; COLOR: #000000; FONT-STYLE: normal; FONT-WEIGHT: 400">8696.44</SPAN></TD>
<TD ALIGN="left" DIR="LTR"><SPAN STYLE="FONT-SIZE: 7pt; FONT-FAMILY: Arial; COLOR: #000000; FONT-STYLE: normal; FONT-WEIGHT: 400">25.05.23</SPAN></TD>
</TR>
<TR>
<TD ALIGN="left" DIR="LTR"><SPAN STYLE="FONT-SIZE: 7pt; FONT-FAMILY: Arial; COLOR: #000000; FONT-STYLE: normal; FONT-WEIGHT: 400">07</SPAN></TD>
<TD ALIGN="left" DIR="LTR"><SPAN STYLE="FONT-SIZE: 7pt; FONT-FAMILY: Arial; COLOR: #000000; FONT-STYLE: normal; FONT-WEIGHT: 400">0108</SPAN></TD>
<TD ALIGN="left" DIR="LTR"><SPAN STYLE="FONT-SIZE: 7pt; FONT-FAMILY: Arial; COLOR: #000000; FONT-STYLE: normal; FONT-WEIGHT: 400">16</SPAN></TD>
<TD ALIGN="left" DIR="LTR"><SPAN STYLE="FONT-SIZE: 7pt; FONT-FAMILY: Arial; COLOR: #000000; FONT-STYLE: normal; FONT-WEIGHT: 400">PM</SPAN></TD>
<TD ALIGN="left" DIR="LTR"><SPAN STYLE="FONT-SIZE: 7pt; FONT-FAMILY: Arial; COLOR: #000000; FONT-STYLE: normal; FONT-WEIGHT: 400">47</SPAN></TD>
<TD ALIGN="left" DIR="LTR"><SPAN STYLE="FONT-SIZE: 7pt; FONT-FAMILY: Arial; COLOR: #000000; FONT-STYLE: normal; FONT-WEIGHT: 400">1</SPAN></TD>
<TD ALIGN="left" DIR="LTR"><SPAN STYLE="FONT-SIZE: 7pt; FONT-FAMILY: Arial; COLOR: #000000; FONT-STYLE: normal; FONT-WEIGHT: 400"> 319772</SPAN></TD>
<TD ALIGN="left" DIR="LTR"><SPAN STYLE="FONT-SIZE: 7pt; FONT-FAMILY: Arial; COLOR: #000000; FONT-STYLE: normal; FONT-WEIGHT: 400">ODVIJAČ</SPAN></TD>
<TD ALIGN="left" DIR="LTR"><SPAN STYLE="FONT-SIZE: 7pt; FONT-FAMILY: Arial; COLOR: #000000; FONT-STYLE: normal; FONT-WEIGHT: 400">2.00</SPAN></TD>
<TD ALIGN="left" DIR="LTR"><SPAN STYLE="FONT-SIZE: 7pt; FONT-FAMILY: Arial; COLOR: #000000; FONT-STYLE: normal; FONT-WEIGHT: 400">.00</SPAN></TD>
<TD ALIGN="left" DIR="LTR"><SPAN STYLE="FONT-SIZE: 7pt; FONT-FAMILY: Arial; COLOR: #000000; FONT-STYLE: normal; FONT-WEIGHT: 400">4348.22</SPAN></TD>
<TD ALIGN="left" DIR="LTR"><SPAN STYLE="FONT-SIZE: 7pt; FONT-FAMILY: Arial; COLOR: #000000; FONT-STYLE: normal; FONT-WEIGHT: 400">8696.44</SPAN></TD>
<TD ALIGN="left" DIR="LTR"><SPAN STYLE="FONT-SIZE: 7pt; FONT-FAMILY: Arial; COLOR: #000000; FONT-STYLE: normal; FONT-WEIGHT: 400">.00</SPAN></TD>
<TD ALIGN="left" DIR="LTR"><SPAN STYLE="FONT-SIZE: 7pt; FONT-FAMILY: Arial; COLOR: #000000; FONT-STYLE: normal; FONT-WEIGHT: 400">25.05.23</SPAN></TD>
</TR>
</TABLE>
</body>
</html>
Top
User avatar
dragancesu
Posts: 930
Joined: Mon Jun 24, 2013 11:53 am
DBs Used: DBF, MySQL, Oracle
Location: Subotica, Serbia

Re: one more format for excel

Post by dragancesu »

Yes, it is. But it suprise for me how excel easy read html file
Top
EduardoLuis
Posts: 684
Joined: Tue Jun 04, 2013 6:33 pm
Location: Argentina

Re: one more format for excel

Post by EduardoLuis »

Hi Dragancesu:

Search for some samples published by Brunello Pullix, who wrote a complete sample of conversions to XLS word and Pdf formats.
Search for XRTF - if i dont remember wrong -
Hopping these can help you, with regards.
Eduardo
Top
Post Reply

Return to “HMG General Help”