Output a pandas dataframe to .XLSB (Excel Binary Workbook) format












1















Is it possible to output a pandas dataframe with extension as .XLSB using Python 3 (my version is 3.7.1)? These are huge files (1,000,000+ rows and 60+ columns).



Any guidance on if at all this is possible would be greatly appreciated.










share|improve this question





























    1















    Is it possible to output a pandas dataframe with extension as .XLSB using Python 3 (my version is 3.7.1)? These are huge files (1,000,000+ rows and 60+ columns).



    Any guidance on if at all this is possible would be greatly appreciated.










    share|improve this question



























      1












      1








      1








      Is it possible to output a pandas dataframe with extension as .XLSB using Python 3 (my version is 3.7.1)? These are huge files (1,000,000+ rows and 60+ columns).



      Any guidance on if at all this is possible would be greatly appreciated.










      share|improve this question
















      Is it possible to output a pandas dataframe with extension as .XLSB using Python 3 (my version is 3.7.1)? These are huge files (1,000,000+ rows and 60+ columns).



      Any guidance on if at all this is possible would be greatly appreciated.







      python python-3.x pandas






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited Nov 24 '18 at 20:00









      petezurich

      3,52581734




      3,52581734










      asked Nov 24 '18 at 19:38









      Code_SipraCode_Sipra

      477620




      477620
























          1 Answer
          1






          active

          oldest

          votes


















          -1














          Support for xlsb is not available - https://github.com/pandas-dev/pandas/issues/8540






          share|improve this answer


























          • Were you able to open the output file in excel? I tried the to_csv method. I am getting a message saying Excel cannot open the file because the file format or file extension is not valid. Doesn't a delimiter have to be used?

            – Code_Sipra
            Nov 24 '18 at 19:56











          • its not opening for me, However if you are on windows you can use open and repair option . update in case you find another solution.

            – Subha Saha
            Nov 24 '18 at 20:23











          • Just of curiosity , are you planning to use xlsb file for analysis purpose ?

            – Subha Saha
            Nov 24 '18 at 20:24











          • Yes. These files will be used for some data analysis. Unfortunately, I wouldn't prefer to use the repair option without knowing what the output file contains. These being production files, the risk of data getting corrupted is too high. Hence, I am looking for a solution where no user intervention is required.

            – Code_Sipra
            Nov 24 '18 at 20:34











          • well am not sure if .XLSB is the right option while handling (1,000,000+ rows and 60+ columns) of data. Possible chances it will lag.

            – Subha Saha
            Nov 24 '18 at 20:58











          Your Answer






          StackExchange.ifUsing("editor", function () {
          StackExchange.using("externalEditor", function () {
          StackExchange.using("snippets", function () {
          StackExchange.snippets.init();
          });
          });
          }, "code-snippets");

          StackExchange.ready(function() {
          var channelOptions = {
          tags: "".split(" "),
          id: "1"
          };
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function() {
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled) {
          StackExchange.using("snippets", function() {
          createEditor();
          });
          }
          else {
          createEditor();
          }
          });

          function createEditor() {
          StackExchange.prepareEditor({
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: true,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: 10,
          bindNavPrevention: true,
          postfix: "",
          imageUploader: {
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          },
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          });


          }
          });














          draft saved

          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53461728%2foutput-a-pandas-dataframe-to-xlsb-excel-binary-workbook-format%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown

























          1 Answer
          1






          active

          oldest

          votes








          1 Answer
          1






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes









          -1














          Support for xlsb is not available - https://github.com/pandas-dev/pandas/issues/8540






          share|improve this answer


























          • Were you able to open the output file in excel? I tried the to_csv method. I am getting a message saying Excel cannot open the file because the file format or file extension is not valid. Doesn't a delimiter have to be used?

            – Code_Sipra
            Nov 24 '18 at 19:56











          • its not opening for me, However if you are on windows you can use open and repair option . update in case you find another solution.

            – Subha Saha
            Nov 24 '18 at 20:23











          • Just of curiosity , are you planning to use xlsb file for analysis purpose ?

            – Subha Saha
            Nov 24 '18 at 20:24











          • Yes. These files will be used for some data analysis. Unfortunately, I wouldn't prefer to use the repair option without knowing what the output file contains. These being production files, the risk of data getting corrupted is too high. Hence, I am looking for a solution where no user intervention is required.

            – Code_Sipra
            Nov 24 '18 at 20:34











          • well am not sure if .XLSB is the right option while handling (1,000,000+ rows and 60+ columns) of data. Possible chances it will lag.

            – Subha Saha
            Nov 24 '18 at 20:58
















          -1














          Support for xlsb is not available - https://github.com/pandas-dev/pandas/issues/8540






          share|improve this answer


























          • Were you able to open the output file in excel? I tried the to_csv method. I am getting a message saying Excel cannot open the file because the file format or file extension is not valid. Doesn't a delimiter have to be used?

            – Code_Sipra
            Nov 24 '18 at 19:56











          • its not opening for me, However if you are on windows you can use open and repair option . update in case you find another solution.

            – Subha Saha
            Nov 24 '18 at 20:23











          • Just of curiosity , are you planning to use xlsb file for analysis purpose ?

            – Subha Saha
            Nov 24 '18 at 20:24











          • Yes. These files will be used for some data analysis. Unfortunately, I wouldn't prefer to use the repair option without knowing what the output file contains. These being production files, the risk of data getting corrupted is too high. Hence, I am looking for a solution where no user intervention is required.

            – Code_Sipra
            Nov 24 '18 at 20:34











          • well am not sure if .XLSB is the right option while handling (1,000,000+ rows and 60+ columns) of data. Possible chances it will lag.

            – Subha Saha
            Nov 24 '18 at 20:58














          -1












          -1








          -1







          Support for xlsb is not available - https://github.com/pandas-dev/pandas/issues/8540






          share|improve this answer















          Support for xlsb is not available - https://github.com/pandas-dev/pandas/issues/8540







          share|improve this answer














          share|improve this answer



          share|improve this answer








          edited Jan 7 at 6:53

























          answered Nov 24 '18 at 19:48









          Subha SahaSubha Saha

          177




          177













          • Were you able to open the output file in excel? I tried the to_csv method. I am getting a message saying Excel cannot open the file because the file format or file extension is not valid. Doesn't a delimiter have to be used?

            – Code_Sipra
            Nov 24 '18 at 19:56











          • its not opening for me, However if you are on windows you can use open and repair option . update in case you find another solution.

            – Subha Saha
            Nov 24 '18 at 20:23











          • Just of curiosity , are you planning to use xlsb file for analysis purpose ?

            – Subha Saha
            Nov 24 '18 at 20:24











          • Yes. These files will be used for some data analysis. Unfortunately, I wouldn't prefer to use the repair option without knowing what the output file contains. These being production files, the risk of data getting corrupted is too high. Hence, I am looking for a solution where no user intervention is required.

            – Code_Sipra
            Nov 24 '18 at 20:34











          • well am not sure if .XLSB is the right option while handling (1,000,000+ rows and 60+ columns) of data. Possible chances it will lag.

            – Subha Saha
            Nov 24 '18 at 20:58



















          • Were you able to open the output file in excel? I tried the to_csv method. I am getting a message saying Excel cannot open the file because the file format or file extension is not valid. Doesn't a delimiter have to be used?

            – Code_Sipra
            Nov 24 '18 at 19:56











          • its not opening for me, However if you are on windows you can use open and repair option . update in case you find another solution.

            – Subha Saha
            Nov 24 '18 at 20:23











          • Just of curiosity , are you planning to use xlsb file for analysis purpose ?

            – Subha Saha
            Nov 24 '18 at 20:24











          • Yes. These files will be used for some data analysis. Unfortunately, I wouldn't prefer to use the repair option without knowing what the output file contains. These being production files, the risk of data getting corrupted is too high. Hence, I am looking for a solution where no user intervention is required.

            – Code_Sipra
            Nov 24 '18 at 20:34











          • well am not sure if .XLSB is the right option while handling (1,000,000+ rows and 60+ columns) of data. Possible chances it will lag.

            – Subha Saha
            Nov 24 '18 at 20:58

















          Were you able to open the output file in excel? I tried the to_csv method. I am getting a message saying Excel cannot open the file because the file format or file extension is not valid. Doesn't a delimiter have to be used?

          – Code_Sipra
          Nov 24 '18 at 19:56





          Were you able to open the output file in excel? I tried the to_csv method. I am getting a message saying Excel cannot open the file because the file format or file extension is not valid. Doesn't a delimiter have to be used?

          – Code_Sipra
          Nov 24 '18 at 19:56













          its not opening for me, However if you are on windows you can use open and repair option . update in case you find another solution.

          – Subha Saha
          Nov 24 '18 at 20:23





          its not opening for me, However if you are on windows you can use open and repair option . update in case you find another solution.

          – Subha Saha
          Nov 24 '18 at 20:23













          Just of curiosity , are you planning to use xlsb file for analysis purpose ?

          – Subha Saha
          Nov 24 '18 at 20:24





          Just of curiosity , are you planning to use xlsb file for analysis purpose ?

          – Subha Saha
          Nov 24 '18 at 20:24













          Yes. These files will be used for some data analysis. Unfortunately, I wouldn't prefer to use the repair option without knowing what the output file contains. These being production files, the risk of data getting corrupted is too high. Hence, I am looking for a solution where no user intervention is required.

          – Code_Sipra
          Nov 24 '18 at 20:34





          Yes. These files will be used for some data analysis. Unfortunately, I wouldn't prefer to use the repair option without knowing what the output file contains. These being production files, the risk of data getting corrupted is too high. Hence, I am looking for a solution where no user intervention is required.

          – Code_Sipra
          Nov 24 '18 at 20:34













          well am not sure if .XLSB is the right option while handling (1,000,000+ rows and 60+ columns) of data. Possible chances it will lag.

          – Subha Saha
          Nov 24 '18 at 20:58





          well am not sure if .XLSB is the right option while handling (1,000,000+ rows and 60+ columns) of data. Possible chances it will lag.

          – Subha Saha
          Nov 24 '18 at 20:58


















          draft saved

          draft discarded




















































          Thanks for contributing an answer to Stack Overflow!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid



          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.


          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53461728%2foutput-a-pandas-dataframe-to-xlsb-excel-binary-workbook-format%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          A CLEAN and SIMPLE way to add appendices to Table of Contents and bookmarks

          Calculate evaluation metrics using cross_val_predict sklearn

          Insert data from modal to MySQL (multiple modal on website)