Read a csv or xls C#

[Joel_Bailie (Joel Ray Bailie)]

I have been asked to create a kinetic function that will read a xls or csv file. The function will have to detect which type of file it is and read it accordingly line by line. Do any of you have any C# examples on how to do this?

[klincecum (Kevin Lincecum)]

Got one coming this week. Writing it up.

In the meantime, for CSV one already exists.

How To: Kinetic - Upload a Client File, Parse, and Display in a Grid

Another How To for how to use the File Picker Client control and file-erp-transfer widget. This tutorial will go over how to wire up the controls, pass the file to a function, parse the data, return the dataset to App Studio, and display the rows in a grid. Create a DataView holder [image] Create a grid and bind it to the new DataView from Step 1. [image] Add the File Picker Client (or server) control to your form and bind it to something. I used TransView because it’s runtime and I d…

[klincecum (Kevin Lincecum)]

@klincecum

Got one coming this week. Writing 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…

[Joel_Bailie (Joel Ray Bailie)]

Thank you. I am working on this now.