A tool for converting XPS files to XLSX files. Specifically, this maps out the location of data within the XPS and collates based on X and Y coordinates. This is useful for automating data capture fom XPS documents without having to manually copy and paste. Specific areas of the page can be targeted and content pulled.
Daniel Clarke
Dedicated, Analytic, Professional
Tagged: convert
A simple script to create CSV versions of any XLSX files in a given folder. #The Basics import xlrd import csv import os import re # Create empty variables and hash tables we’ll need later Location = {} # Location to output CSV file when all is done Location[‘input’] = input(‘Folder: ‘) Location[‘output’] = os.path.join(Location[‘input’],’csv’) def csv_from_excel(file): print(“Parsing “, file) wb = xlrd.open_workbook(file) for sheet in wb.sheet_names(): print(‘Exporting Sheet:’, sheet) sh = wb.sheet_by_name(sheet) fileout = os.path.splitext(file)[0] + ” ” + sheet + “.csv” with open(fileout, “w”, newline=””) as csvfile: wr = csv.writer(csvfile, quoting=csv.QUOTE_ALL) for rownum in range(sh.nrows): wr.writerow(sh.row_values(rownum)) csvfile.close() # […]