Has Anyone Successfully Read an Excel File (.xls/.xlsx) from an Epicor Function?

[klincecum (Kevin Lincecum)]

@klincecum

I gotta go write it up

Excel Upload, Parse, Show in Grid -> With Extras

As promised, here is a function library and a HowTo on how to work with excel files. Go to that thread, and install and promote that library, then come back here Set up an app like so: [image] This is a panel, two grids inside, a file box, and a button. TransView [image] Set up a TransView to hold the FileName. [image] Set up an even on Window OnLoad to add a row to the TransView. That json is {"FileName": null} File Box → [image] [image] Grid Data Views → [image…

ExcelOperations Library - ExcelToDataSet, DataSetToExcel

ExcelOperations Library - ExcelToDataSet, DataSetToExcel This function library does two things mainly. Takes an Excel binary (.xlsx) and exports it to a DataSet. Takes a DataSet and exports it to an Excel binary. (.xlsx) It also includes a helper function that will open an excel file on the server, and run it through the ExcelToDataSet function for you. ExcelToDataSet will export all sheets in an excel file (.xlsx) to a DataSet. Each sheet get’s it’s own table. DataSetToExcel will export a…