title: Python XLSB to CSV conversion data types
body: <p>I've been working on creating a script which converts Excel files into csv for further processing in some of our tools.</p>
  
  <p>For xls, xlsx and xlsm i've found solutions in opening the file as text object or using pandas. When encountering xlsb files i landed on the pyxlsb package, which works... refer to the code used here <a href="https://stackoverflow.com/questions/22366200/how-can-i-convert-a-xlsb-file-to-csv-using-python">How can I convert a XLSB file to csv using python?</a></p>
  
  <p>Sadly i noticed that int() values in the xlsb file seem to be converted to float and consequently written in my csv file as a float. This is obviously undesirable. </p>
  
  <p>Basically i'm looking for a dtype=object type solution. I figured maybe i can ad a step of converting the values back to int with another function. However i think that's inefficient and prone to errors. </p>
  
  <p>I've looked around on the pyxlsb page (<a href="https://pypi.org/project/pyxlsb/" rel="nofollow noreferrer">https://pypi.org/project/pyxlsb/</a>) without luck.</p>
  
  <p>My code:</p>
  
  <pre><code>    to_replace_list = ['\r', '\n', '\\r\\n', '\\' + str(out_del)]  # values to replace in all rows
      with open_xlsb(file_to_convert) as wb:  # open xlsb file using pyxlsb package
          for sheet_name in wb.sheets:  # loop over all sheets in file
              with wb.get_sheet(sheet_name) as sheet:  # open xlsb sheet obj
                  out_file = out_filer(total_filename, sheet_name)  # define output file name based on source and sheet
                  with open(out_file, 'a') as o:  # open output csv obj
                      for row in sheet.rows():  # loop over rows in xlsb obj
                          print([re.sub(value, '', str(cell.v)) for value in to_replace_list for cell in row])
  </code></pre>
  
  <p>sidequest: empty values in the xlsb file will be referred to as None in the output. I would like this to be ''.</p>