Questions tagged as 'xls'

2
answers

What is the best way to read an XLS file?

I would like to know the best way to read an XLS file in C #. Can I treat it the same way I treat a table in the database?     
asked by 12.05.2014 / 19:44
3
answers

Organize data in Excel to open as table in R?

I have a file with 50 comments and 3 variables in Excel (.xlsx) file, and I made it into .csv. I used banco1<- read.csv("teste1.csv") to create the table in R, but my 3 variables appear in the same column. How do I make them appear sep...
asked by 29.09.2014 / 05:19
1
answer

Convert Excel (.xls) to (.htm)?

I made a system for a school, where from the Excel file, where all school bulletins are stored, I export to .htm , where it generates some files with this extension and from there I can make the cut of the bulletins and comparing them with...
asked by 21.12.2016 / 15:57
3
answers

Convert JSON to EXCEL

I have a ajax query that returns a Json with an array of objects, how can I turn this json into excel? My json example: [ {idcancelamento: "383", idcliente: "2409", emailcancelamento: "1", financeiro: "1", suporte: "1"}, {idcancela...
asked by 23.10.2017 / 19:19
1
answer

Doubt in string comparison and list value for all rows

I have a table of 5 rows and 5 columns. For each column I have a name, for example: Name, Age, Sex, Weight, Height. And all 5 * 5 cells are filled. I need the following formatting: Idade João - 15 José - 16 Maria - 21 Sexo João - M José -...
asked by 27.08.2014 / 16:24
1
answer

Read merged rows and columns in excel, using python

I'm having trouble reading information from a spreadsheet that has merged rows and columns. I tried using merged_cell to get the value, but I do not understand how it works. Can anyone help me? Using the script below, I can get the values, e...
asked by 21.08.2014 / 21:15
1
answer

Reading XLS in Java

I have a class to read an xls in java, and I need to know how to print one column next to another as well as in xls itself. So far I've only been able to print in a single race or online. NOTE: I'm using the jxl library. Follow the code:...
asked by 21.12.2016 / 17:47
1
answer

Separate result in different worksheets

I have a problem in which I have to get all my information (information from each cell of the worksheet), make them go through a condition and for each condition result write to a new worksheet of a new file. For example, I have the test.xls...
asked by 03.09.2014 / 15:31
2
answers

String Connection excel .xls .xlsx C #

I have a connection string with excel, but it is only .xlsx and is giving this error    ServerVersion = 'connExcel.ServerVersion' threw an exception of type   'System.InvalidOperationException' I need a connection with both at the same ti...
asked by 02.09.2014 / 16:00
2
answers

Read more than one .xls file in python

I asked a very similar question a few days ago, but this time, I'm trying to do something much more generic. I want to get the information from line 0 and 1. The code below is complete, and is outputting the input.xls file correctly. import xl...
asked by 25.09.2014 / 13:47