def sheet_to_csv(workbook_path, csv_path, sheet_name):
from pyxform.xls2json_backends import xls_value_to_unicode
wb = xlrd.open_workbook(workbook_path)
try:
sheet = wb.sheet_by_name(sheet_name)
except xlrd.biffh.XLRDError:
return False
if not sheet or sheet.nrows < 2:
return False
with open(csv_path, "w", newline="") as f:
writer = csv.writer(f, quoting=csv.QUOTE_ALL)
mask = [v and len(v.strip()) > 0 for v in sheet.row_values(0)]
for row_idx in range(sheet.nrows):
csv_data = []
try:
for v, m in zip(sheet.row(row_idx), mask):
if m:
value = v.value
value_type = v.ctype
data = xls_value_to_unicode(value, value_type,
wb.datemode)
# clean the values of leading and trailing whitespaces
data = data.strip()
csv_data.append(data)
except TypeError:
continue
writer.writerow(csv_data)
return True
def sheet_to_csv(workbook_path, csv_path, sheet_name):
from pyxform.xls2json_backends import xls_value_to_unicode
wb = xlrd.open_workbook(workbook_path)
try:
sheet = wb.sheet_by_name(sheet_name)
except xlrd.biffh.XLRDError:
return False
if not sheet or sheet.nrows < 2:
return False
with open(csv_path, "wb") as f:
writer = csv.writer(f, quoting=csv.QUOTE_ALL)
mask = [v and len(v.strip()) > 0 for v in sheet.row_values(0)]
for row_idx in range(sheet.nrows):
csv_data = []
if mask:
try:
for v, mask in zip(sheet.row(row_idx), mask):
value = v.value
value_type = v.ctype
data = xls_value_to_unicode(value, value_type, wb.datemode)
csv_data.append(data)
except TypeError:
continue
writer.writerow(csv_data)
return True
def test_xls_value_to_unicode(self):
"""
Test external choices sheet with numeric values is processed successfully.
The test ensures that the integer values within the external choices sheet
are returned as they were initially received.
"""
value = 32.0
value_type = xlrd.XL_CELL_NUMBER
datemode = 1
csv_data = xls_value_to_unicode(value, value_type, datemode)
expected_output = "32"
self.assertEqual(csv_data, expected_output)
# Test that the decimal value is not changed during conversion.
value = 46.9
csv_data = xls_value_to_unicode(value, value_type, datemode)
expected_output = "46.9"
self.assertEqual(csv_data, expected_output)
def test_xls_value_to_unicode(self):
"""
Test external choices sheet with numeric values is processed successfully.
The test ensures that the integer values within the external choices sheet
are returned as they were initially received.
"""
value = 32.0
value_type = xlrd.XL_CELL_NUMBER
datemode = 1
csv_data = xls_value_to_unicode(value, value_type, datemode)
expected_output = "32"
self.assertEqual(csv_data, expected_output)
# Test that the decimal value is not changed during conversion.
value = 46.9
csv_data = xls_value_to_unicode(value, value_type, datemode)
expected_output = "46.9"
self.assertEqual(csv_data, expected_output)