Skip to content

Import into Postgres directly from SpreadsheetML format w/o the use of CSV

License

Notifications You must be signed in to change notification settings

stefanov-sm/Read-Excel-into-PostgreSQL

Repository files navigation

Read-Office-XML-into-PostgreSQL-table

Import into Postgres directly from SpreadsheetML format w/o CSV use

Save workbook as Office XML

  • Checks the risk of data distortion by the CSV generation as it may depend on regional settings.
  • May be ported to other RDBMS that support SQL-standard XMLTABLE.
  • usage.sql is a working example that uses ecb.xlsx spreadsheet.

XLS[X] to XML conversion scripts and sample files in convert folder.
Example CLI usage: cscript xlsx2xml.wsf <input xls[x] file full name> <output xml file full name>

About

Import into Postgres directly from SpreadsheetML format w/o the use of CSV

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published