import xlutils, xypath
import databaker
import os
import databaker.constants
from databaker.constants import *      # also brings in template
import databaker.databakersolo as ds   # causes the xypath.loader to be overwritten
from databaker.jupybakeutils import HDim, HDimConst, savepreviewhtml, writetechnicalCSV, ConversionSegment

def loadxlstabs(inputfile):
    print("Loading %s which has size %d bytes" % (inputfile, os.path.getsize(inputfile)))
    tableset = xypath.loader.table_set(inputfile, extension='xls')
    tabs = list(xypath.loader.get_sheets(tableset, "*"))
    print("Table names: %s" % ", ".join([tab.name  for tab in tabs]))
    return tabs
    
import pandas as pd
def topandas(conversionsegment):
    return pd.DataFrame.from_dict(conversionsegment.lookupall())

import xlutils, xypath
import databaker
import os
import databaker.constants
from databaker.constants import *      # also brings in template
import databaker.databakersolo as ds   # causes the xypath.loader to be overwritten
from databaker.jupybakeutils import HDim, HDimConst, savepreviewhtml, writetechnicalCSV, ConversionSegment

def loadxlstabs(inputfile, sheetids="*"):
    print("Loading %s which has size %d bytes" % (inputfile, os.path.getsize(inputfile)))
    tableset = xypath.loader.table_set(inputfile, extension='xls')
    tabs = list(xypath.loader.get_sheets(tableset, sheetids))
    print("Table names: %s" % ", ".join([tab.name  for tab in tabs]))
    return tabs
    
import pandas as pd
def topandas(conversionsegment):
    return pd.DataFrame.from_dict(conversionsegment.lookupall())

Add table sheet selection capabilit
Add table sheet selection capabilit

  import xlutils, xypath
  import databaker
  import os
  import databaker.constants
  from databaker.constants import *      # also brings in template
  import databaker.databakersolo as ds   # causes the xypath.loader to be overwritten
  from databaker.jupybakeutils import HDim, HDimConst, savepreviewhtml, writetechnicalCSV, ConversionSegment
  
- def loadxlstabs(inputfile):
+ def loadxlstabs(inputfile, sheetids="*"):
      print("Loading %s which has size %d bytes" % (inputfile, os.path.getsize(inputfile)))
      tableset = xypath.loader.table_set(inputfile, extension='xls')
-     tabs = list(xypath.loader.get_sheets(tableset, "*"))
+     tabs = list(xypath.loader.get_sheets(tableset, sheetids))
      print("Table names: %s" % ", ".join([tab.name  for tab in tabs]))
      return tabs
      
  import pandas as pd
  def topandas(conversionsegment):
      return pd.DataFrame.from_dict(conversionsegment.lookupall())
  
Add table sheet selection capabilit
## Code Before:
import xlutils, xypath
import databaker
import os
import databaker.constants
from databaker.constants import *      # also brings in template
import databaker.databakersolo as ds   # causes the xypath.loader to be overwritten
from databaker.jupybakeutils import HDim, HDimConst, savepreviewhtml, writetechnicalCSV, ConversionSegment

def loadxlstabs(inputfile):
    print("Loading %s which has size %d bytes" % (inputfile, os.path.getsize(inputfile)))
    tableset = xypath.loader.table_set(inputfile, extension='xls')
    tabs = list(xypath.loader.get_sheets(tableset, "*"))
    print("Table names: %s" % ", ".join([tab.name  for tab in tabs]))
    return tabs
    
import pandas as pd
def topandas(conversionsegment):
    return pd.DataFrame.from_dict(conversionsegment.lookupall())

## Instruction:
Add table sheet selection capabilit
## Code After:
import xlutils, xypath
import databaker
import os
import databaker.constants
from databaker.constants import *      # also brings in template
import databaker.databakersolo as ds   # causes the xypath.loader to be overwritten
from databaker.jupybakeutils import HDim, HDimConst, savepreviewhtml, writetechnicalCSV, ConversionSegment

def loadxlstabs(inputfile, sheetids="*"):
    print("Loading %s which has size %d bytes" % (inputfile, os.path.getsize(inputfile)))
    tableset = xypath.loader.table_set(inputfile, extension='xls')
    tabs = list(xypath.loader.get_sheets(tableset, sheetids))
    print("Table names: %s" % ", ".join([tab.name  for tab in tabs]))
    return tabs
    
import pandas as pd
def topandas(conversionsegment):
    return pd.DataFrame.from_dict(conversionsegment.lookupall())
