Excel XML Creation with Qt's Dom classes

[jpujolf]

Hi all,

I'm trying to create an Excel XML workbook ( I didn't want, but it's strictly necessary )

I've to build an "export to Excel" option in my "very-fashioned-and-colored-grid" that runs on a linux machine, because all my users use windows as client and I have to allow them to manipulate data externally.

I have made a "CSV-export" option, but they want too the colors and some other options and they don't like to import every time ( as csv forces them to do ).

An Excel.xml file looks like this :

&#65279;<?xml version="1.0"?>
 
<?mso-application progid="Excel.Sheet"?>
 
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
 
 xmlns:o="urn:schemas-microsoft-com:office:office"
 
 xmlns:x="urn:schemas-microsoft-com:office:excel"
 
 xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
 
 xmlns:html="http://www.w3.org/TR/REC-html40">
...
</Workbook>

<?xml version="1.0"?>

<?mso-application progid="Excel.Sheet"?>

<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"

 xmlns:o="urn:schemas-microsoft-com:office:office"

 xmlns:x="urn:schemas-microsoft-com:office:excel"

 xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"

 xmlns:html="http://www.w3.org/TR/REC-html40">
...
</Workbook>

To copy to clipboard, switch view to plain text mode 

The ... zone is trivial ( simple sections easy to do with Qt's classes ), but I don't know how to generate the first 2 lines that begin with "<?".

Any idea ?

Thanks in advance,

Jordi.

[wysota]

These are called "processing instructions", so QDomDocument::createProcessingInstruction() should be the way to go.

[patrik08]

Hi all,

I'm trying to create an Excel XML workbook ( I didn't want, but it's strictly necessary )
I have made a "CSV-export" option, but they want too the colors and some other options and they don't like to import every time ( as csv forces them to do ).
Any idea ?

Jordi.

have you see my first qt4 projekt...

http://sourceforge.net/projects/qtexcel-xslt/ 4000 downloads...

from xmlexcel 2003 to sqlite3
http://kent.dl.sourceforge.net/sourc.../excel2003.xsl
xml direct to excel 95
http://kent.dl.sourceforge.net/sourc...lsql2excel.xsl
xml to fop pdf
http://kent.dl.sourceforge.net/sourc.../xmlsql2fo.xsl

the fastet way is http://en.wikipedia.org/wiki/XSLT

qt4 dom have trouble if file having more as 4-5 MB

a good CSV to sqlite you can find on http://sqlitebrowser.sourceforge.net/ source...


on http://sourceforge.net/projects/visual-xsltproc/ source, i think you find more ...

lib xslt is easy on linux and mac ... on window on mingw minimal system
http://www.complex-computer.de/album...piling_libxml2

on Visual Studio i dont know....

[jpujolf]

I've been looking at the documentation, but I didn't see that ( I'm blind... )

Many thanks !!!! It works fine...

[patrik08]

more simple .. you make to your client the csv export direct editable ... like the edit model tablelist from a qt book ... i attach ...

its split the csv file and make direct on a table your own excel ...

and run on all os..

QFile file("addressbook.csv");
  if ( !file.open(QIODevice::ReadOnly|QIODevice::Text) )
	  return 1;
  // Adressen auslesen und zeilenweise in Stringliste einlesen
  QString addresses = QString::fromUtf8(file.readAll());
  QStringList records = addresses.split('\n');
 
  // Erste Zeile (Ãœberschriften) entnehmen und aufspalten
  QString header = records.takeAt(0);
  QStringList headers = splitCSVLine(header);
 
QStringList splitCSVLine(const QString& line)
{
  int inItem = false;
  QStringList items;
  QString item;
 
  for (int pos = 0; pos < line.length(); pos++)
  {
    QChar c = line.at(pos);
    if ( c == '\"') {
      if (inItem) {
        items.append(item);
        item = "";
      }
      inItem = !inItem;
    }
    else 
      if (inItem)
         item += c;
  }
  return items;
}

QFile file("addressbook.csv");
  if ( !file.open(QIODevice::ReadOnly|QIODevice::Text) )
	  return 1;
  // Adressen auslesen und zeilenweise in Stringliste einlesen
  QString addresses = QString::fromUtf8(file.readAll());
  QStringList records = addresses.split('\n');

  // Erste Zeile (Ãœberschriften) entnehmen und aufspalten
  QString header = records.takeAt(0);
  QStringList headers = splitCSVLine(header);

QStringList splitCSVLine(const QString& line)
{
  int inItem = false;
  QStringList items;
  QString item;

  for (int pos = 0; pos < line.length(); pos++)
  {
    QChar c = line.at(pos);
    if ( c == '\"') {
      if (inItem) {
        items.append(item);
        item = "";
      }
      inItem = !inItem;
    }
    else 
      if (inItem)
         item += c;
  }
  return items;
}

To copy to clipboard, switch view to plain text mode