db2 - Export SQL query results into a multi tabbed Excel spreadsheet -

-

I want to write a set of query selects 100 DB2 10.1 to return all the rows in each table in the database And the result is exported to Excel spreadsheets with a new tab for each result set

Is this possible and if so, how can I do this?

At the moment I only way to do that, I do think that is exported to set each result and then manually copying each tab multi-tab spreadsheet

Thank you

After

You can use APIs for Excel with scripting languages ​​like VB scripts. 

  'class that used to export Excel file set xls = CreateObject (result set "square format" EasyXLS.ExcelDocument "): 
 VBS this with a code XlsAutoFormat = CreateObject ("EasyXLS.ExcelAutoFormat") for xlsAutoFormat.InitAs (AUTOFORMAT_EASYXLS1) query = 1 to 100 'Add a new sheet xls.easy_addWorksheet_2 ("Sheet" and query) Set xlsSheet = xls to be same as cells should be similar XlsAutoFormat set. easy_getSheetAt (Q - 1) "Create record set object dim objResultSet set objResultSet = CreateObject (" ADODB.Recordset ") objResultSet.Open query string, objDBConnection Set the result that is set in the list set the lstRows will store the values ​​of lstRows = CreateObject ("EasyXLS.Util.List") Add the header in the list Add the dim lstHeaderRow set lstHeaderRow = CreateObject ("EasyXLS LstHeaderRow.addElement (" Column 1 " ) lstHeaderRow.addElement ( "column 2") lstHeaderRow.addElement ( "column objResultSet.EOF Add inventory values ​​from the database 3") lstRows.addElement (lstHeaderRow) 'Switch = true set RowList = CreateObject ( "EasyXLS.Util.List ") RowList.addElement (" "& amp; In objResultSet ( "Column 1")) RowList.addElement ( "" & amp; objResultSet ( "Column 2")) RowList.addElement ( "" & amp; objResultSet ( "3 columns")) lstRows.addElement (RowList) ' Move the next record objResultSet.MoveNext Loop xlsSheet.easy_insertList_2 lstRows, xlsAutoFormat set the next export result in Excel file xls.easy_WriteXLSFile ("c: \ result set.xls")

This link Also see

If you select a non-scripting language, then there are methods in the API, which can directly insert data from the result set and the lists can be omitted. See another sample.


Comments

Post a Comment

Popular posts from this blog

mysql - How to enter php data into a html multiple select box -

-
I am working on a page that will create a team. I just want to create a selection box which will list all the users of all the users. After that, the user can select more than one friend (i.e. 5) and can send the request to these 5 people to join the team but I am having problems I did this: Select $ sql = "Select i. *, Join * Connect with M * m.id = i.clique_id where adder_id =: id"; $ Stmt = $ db- & gt; Query ($ sql, array ('id' = & gt; $ _SESSION ['id'])); While ($ record = $ stmt-> fetch ()) {$ surname = $ record ['surname']; } and this: & lt; Select multiple = "true" name = "category" well id = "category" name = "category" category = "" & gt; & Lt; Option value = "& lt ;? php echo $ surname ;? & gt;" & Gt; & Lt ;? Php ek $ nickname; ? & Gt; & Lt; / Options & gt; & Lt; / Select & gt; But only a friend's nickname...
Read more

java - Can't add JTree to JPanel of a JInternalFrame -

-
Image
There are two panels in my JInternalframe. I want to add TopPanel to Jtree to nominate another. But I can not add Jaitari to the top of the panel. Please help me in this piece of code: DefaultMutableTreeNode root = new DefaultMutableTreeNode ("deck"); DefaultMutableTreeNode Item Clubs = New DefaultMutableTreeNode ("Club"); AddAllCard (itemClubs); Root.add (itemClubs); DefaultMutableTreeNode item = New DefaultMutableTreeNode ("Diamonds"); AddAllCard (itemDiamonds); Root.add (itemDiamonds); DefaultMutableTreeNode Itemspads = New DefaultMutableTreeNode ("Spades"); AddAllCard (itemSpades); Root.add (itemSpades); DefaultMutableTreeNode item increases = new DefaultMutableTreeNode ("heart"); AddAllCard (itemHearts); Root.add (itemHearts); Default Trimodel Tree Model = New DefaultTreeModel (Route); Tree = new jetty (tree modal); ScrollPane = new JScrollPane (tree); // scrollPane.setViewportView (tree); . ScrollPane.getViewport () add (tr...
Read more

c++ - Cassandra datastax cpp driver - avoiding unnecessary copies -

-
I use the following method to create my insert statement for Cassandra (using datastax cpp driver) : ssStmt1 & lt; & Lt; "Insert some table (...) value (....)" string sStatement1 = ssStmt1.str (); Castestring cass1 = cass_string_init (sStatement1.c_str ()); CassStatement * pStmt1 = cass_statement_new (cass1, 0); I have also tried the following: CassString cass1 = cass_string_init ("Enter some table (id, date, c) value (? ,?,?); "); CassStatement * pStmt1 = cass_statement_new (cass1, 3); Cass_statement_bind_uuid (pStmt1, 0, uuidKey); Cass_statement_bind_int64 (PSTMT1, 1, timestamp); Cass_statement_bind_string (pStmt1, 2, sSomething); The first pattern works with mixed keys, the second is not. The key has a timestamp and a UUID. Timestamp is one of two errors in the field (based on the used bond statement). If bound in this way: cass_statement_bind_int64_by_name (pStmt1, "date", timestamp); I get the following error: Inva...
Read more