|
When using the Excel jdbc driver currently it seems that the data is ordered in rows, with an optional header row. Some of the spreadsheets I need to process are pivoted in that the header information is in the first column, with the data in the other columns. Is there a property I can set to 'pivot' the data ordering ?
|
|
You can find pivot_clause: PIVOT ( aggregate_function(value_column) FOR pivot_column IN (column_list) ) [AS] tableAlias at here. Pure SQL Syntax.
|
Can I run the Excel jdbc driver on a Unix server to process Excel spreadsheets that have been uploaded ?
Does the Excel jdbc driver require Microsoft Excel to be installed before it will run ?
|
|
Yeah. Pure Java, hasn't any relation with MS Excel runtime.
|
Main
webmaster@hxtt.com