{"id":1746,"date":"2013-05-03T02:36:32","date_gmt":"2013-05-03T02:36:32","guid":{"rendered":"http:\/\/www.withdata.com\/ad\/?p=1746"},"modified":"2013-05-03T02:37:37","modified_gmt":"2013-05-03T02:37:37","slug":"fix-bug-on-loading-multiple-excel-sheets-to-database-at-once","status":"publish","type":"post","link":"https:\/\/www.withdata.com\/blog\/fix\/fix-bug-on-loading-multiple-excel-sheets-to-database-at-once.html","title":{"rendered":"Fix bug on loading multiple Excel sheets to database at once"},"content":{"rendered":"<p>An email from a user of <a href=\"\/oraloader.html\">OraLoader<\/a>:<\/p>\n<p>&#8220;I\u00b4m using the functionality xls(All sheets)  and the values in oracle table are allways the sheet 1 repeted n.sheets .<br \/>\nI include 2 columns to the xls file (sheet,consecutive) and never charge to oracle table the sheet 2, even when I count the table and the rows number of inserted data is ok.&#8221;<\/p>\n<p>This bug is caused by OraLoader can not read the 2nd sheet when read the 1st sheet to the end, it read 1st repeatly. <\/p>\n<p>This bug is fixed.<\/p>\n<p>These softwares have the same bug, and are fixed now: <a href=\"\/xlstomdb.html\">XlsToMdb<\/a>,&nbsp;&nbsp;<a href=\"\/xlstodb2.html\">XlsToDB2<\/a>,&nbsp;&nbsp;<a href=\"\/xlstomy.html\">XlsToMy<\/a>,&nbsp;&nbsp;<a href=\"\/xlstosql.html\">XlsToSql<\/a>,&nbsp;&nbsp;<a href=\"\/xlstoora.html\">XlsToOra<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>An email from a user of OraLoader: &#8220;I\u00b4m using the functionality xls(All sheets) and the values in oracle table are allways the sheet 1 repeted n.sheets . I include 2 columns to the xls file (sheet,consecutive) and never charge to oracle table the sheet 2, even when I count the table and the rows number [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[178],"tags":[214],"class_list":["post-1746","post","type-post","status-publish","format-standard","hentry","category-fix","tag-bug-fixes"],"_links":{"self":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/1746","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/comments?post=1746"}],"version-history":[{"count":3,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/1746\/revisions"}],"predecessor-version":[{"id":1749,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/1746\/revisions\/1749"}],"wp:attachment":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/media?parent=1746"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/categories?post=1746"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/tags?post=1746"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}