Most voted "xls" questions
.xls is the default format of files generated by Excel (prior to version 2013, where the extension is . xlsx).
Learn more…47 questions
Sort by count of
-
13
votes3
answers17303
viewsWhat is the best way to read an XLS file?
I would like to know the best way to read an XLS file in C#. I can handle it the same way I handle a database table?
-
11
votes3
answers3977
viewsOrganize data in Excel to open as table in R?
I have a file with 50 observations and 3 variables in Excel file (.xlsx), and turned to .csv. I used banco1<- read.csv("teste1.csv") to create the table in R, however my 3 variables appear in the…
-
7
votes1
answer307
viewsConvert Excel (.xls) to (.htm)?
I made a system for a school, where from the Excel file, where are stored all school newsletters, I export to .htm, where it generates some files with this extension and from there I can cut the…
-
4
votes1
answer2188
viewsRead rows and columns merged in excel, using python
I’m having trouble reading the information from a spreadsheet that has rows and columns merged. I tried to use merged_cell to get the value, but I don’t understand how it works. Can anyone help me?…
-
4
votes1
answer138
viewsDoubt in string comparison and list value for all lines
I have a table of 5 rows and 5 columns. For each column I have a name, for example: Name, Age, Gender, Weight, Height. And all cells 5*5 are filled. I need the following formatting: Idade João - 15…
-
4
votes3
answers6016
viewsConvert JSON to EXCEL
I carry out a consultation ajax that returns me a Json with object array, how can I transform this json in excel? Example of my json: [ {idcancelamento: "383", idcliente: "2409", emailcancelamento:…
-
3
votes2
answers1405
viewsString Connection excel . xls . xlsx C#
I have a connection string with excel, but it is only the . xlsx and is giving this error Serverversion = 'connExcel.Serverversion' threw an Exception of type 'System.Invalidoperationexception' I…
-
3
votes1
answer62
viewsHow to get columns from XLS files in R
Using R tool, I was able to open an XLS file as follows: require(xlsx) coln = function(x) { y = rbind(seq(1, ncol(x))) colnames(y) = colnames(x) rownames(y) = "col.number" return(y) } data =…
-
3
votes1
answer203
viewsSeparate result in different worksheets
I have a problem in which I have to take all my information (information from each cell of the spreadsheet), make them go through a condition and for each result of the condition write in a new…
-
3
votes2
answers2574
viewsRead more than one. xls file in python
I posted 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…
-
3
votes2
answers128
viewsCreate spreadsheet by adding images and changing color of lines
This method creates an Excel spreadsheet, with int and string: public function arrayToXls($input) { // BoF $ret = pack('ssssss', 0x809, 0x8, 0x0, 0x10, 0x0, 0x0); // array_values is used to ensure…
-
3
votes1
answer1262
viewsInsert comment via Function
How to insert a comment with the text of a cell through a Function?
-
3
votes1
answer1191
viewsReading XLS in Java
I have a class to read an xls in java, and I need to know how to print a column next to each other as well as in xls itself. So far I’ve only been able to print in a race or single line. NOTE: I am…
-
2
votes0
answers92
viewsError creating and downloading XLS with Cakephp
I have the following code: $this->autoRender = false; $this->autoLayout = false; $turmaId = base64_decode($turmaId); $turma = $this->Turma->find('first',array( 'conditions'=>array(…
-
2
votes0
answers41
viewsProblems with apostrophos using Phpspreadsheet to write xlsx
I have the following problem, I fill out a spreadsheet with a person’s information, however, names like D'Ana generate a problem in xlsx. D'Anna gets a square instead of the bet. the form of writing…
-
2
votes1
answer136
viewsDoes not download the XLS spreadsheet
The system was in a resale and I had to migrate to a VPS with Cpanel, the script to generate the XLS was working fine, opened and performed the download , but now it just opens on screen What I need…
-
2
votes1
answer98
viewsColumn of unwanted numbers in write.xlsx
I am saving a data frame in excel spreadsheet with the following command: library(xlsx) write.xlsx(df, "buildingTEPT.xlsx", sheetName = "TEPT", showNA = F, col.names = T) It turns out that the…
-
2
votes1
answer167
viewsGenerate default . xls column file
I have a table with 5 columns, whereas the first one has a check box and the last one has a button to delete that particular row. The issue is that I want to export to Excel, in a file .xsl, but…
-
2
votes1
answer466
viewsValidate empty fields in XLSX file - (Epplus) ASP.NET
I am importing an XLSX file into C#, using Excelpackage. I do some validations on import Ex: Numeric, text and if field is empty. Note: If all columns in my file are filled in the import is done…
-
2
votes1
answer669
viewsProblem to export table in xls format with PHP
Good afternoon. I have a button that generates a file . xls that should bring a spreadsheet from an SQL query... The file is generated, the problem is that a message appears in Excel saying that the…
-
2
votes1
answer54
viewsRemoving strings from within a list
Hello I have a list I get from a file xls through the library xlrd workbook = xlrd.open_workbook(r"C:\Users\Expedição\Videos\CSV\produtos_filtrado.xls") # Escolhe o arquivo a ser lido. worksheet =…
-
1
votes1
answer895
viewsRead more than one file tab
My code goes through all cells in my spreadsheet and returns all the values I need, and in this.xls file there is only one tab. Now I have a new file to go through and are 8 tabs. I know I need to…
-
1
votes1
answer647
viewsSelect data from a spreadsheet
I read data from a spreadsheet using Python 3 libraries (xlrd / xlsxwriter / Pandas and Numpy). This spreadsheet has in the rows questions of the survey and in the columns the areas that answered…
-
1
votes1
answer2563
viewsImport XLS to Pgadmin
I am trying to import a spreadsheet with information from a database table, however, when I try to import, give the following message: field 'md5' must have a value However, there are values in this…
-
1
votes1
answer281
viewsExport XLS content in Wordpress admin
I need to export specific content to XLS within the administrative area, and am using the following code: $arquivo = 'planilha.xls'; $html = ''; $html .= '<table>'; $html .= '<tr>';…
-
1
votes1
answer289
viewsRemove duplicates based on one column value
I would like to know how I can perform the following filter: ===> That is, how to remove duplicates in the "action" column, but leaving the record with higher priority (in this case, '1' is the…
-
1
votes0
answers89
viewsGenexus X Ev. 3 - Problems reading Excel(xls)
Hello, I’m having a problem reading xls, just loading and appears at the bottom of the browser "Waiting for localhost(or the server)", I did the test with xlsx works normal. I have done tests on…
-
1
votes3
answers1429
viewsEdit an already created XLS file
I need to edit an XLS file already created, but I am only able to create a new file and delete the old one, so far it is working but I wonder if it is possible to edit the old file and not have to…
-
1
votes1
answer658
viewssave in file a return from backend
my backend controller returns a file of type xlsx to my front, this is the method that makes the return: public FileResult ListarLivrosExcel() { // Gerando minha planilha e recebendo-a using…
-
1
votes1
answer535
viewsImport xls file to R
The data can be obtained by Link <- https://github.com/marcosvafg/salario_juizes But precisely the file name is Salarios_juizes_tjsp_122017. The file is protected, so I can’t change it. I wanted…
-
1
votes0
answers28
viewsSrcset0 task failure (Loading) on MICROSOFT_EXCEL ODBC source
Good morning, I’m trying to configure oracle data Tegrator to read an excel spreadsheet in xls and xlsx formats, but I’m having problems and I can’t find a solution! it returns me the following…
-
1
votes1
answer400
viewsPlotting file . xls with matplotlib and openpyxl
Having the following content in my file . xls: Belo Horizonte - MG 2278.8 Porto Alegre - RS 1647.8 Recife - PE 2434.9 Rio de Janeiro - RJ 1653.6 Salvador - BA 2324.1 São Paulo - SP 2227.5 Total of…
-
1
votes1
answer259
viewsHow to import a file . xls in R keeping accented names in categorical variables?
I imported a file into . xls that contains columns with drug names and their class. Some names have accents like "Antipsychotic", "Benzodiazepine" and "Tricyclic Antidepressant". I used read.xlsx as…
-
0
votes1
answer1850
viewsException when reading excel file using apache poi
I am trying to read an Excel (XLS) file, using the Apache Poi API, and am taking the Exception: java.io.IOException: Invalid header signature; read 0x0020000A000DFEFF, expected 0xE11AB1A1E011CFD0 -…
-
0
votes0
answers47
viewsRead file . xls
I have a problem reading a file . xls using Python with Flask. My code: from openpyxl import load_workbook wb = load_workbook(filename=settings.MEDIA_ROOT + '/xls/arquivo.xls', read_only=True) ws =…
-
0
votes0
answers38
viewsGenerate two XLS Files
I need to generate two files with different names and data in a PHP page, but the code only generates the second, follows a short excerpt of the code: // Primeiro Arquivo for($i=0;$i<1;$i++){…
-
0
votes1
answer41
viewsSynchronize Mysql database with XLS
The situation is as follows. I have a MYSQL database and XLS file on an FTP server The code below downloads the XLS to read and update dos in the database from the XLS data. The problem is that it…
-
0
votes1
answer892
viewsApache POI: how to know if a spreadsheet has come to an end?
I am developing a personal project, and for this I am using Java along with Apache POI to read XLS files, how can I know if the spreadsheet has reached its end? Thanks in advance!
-
0
votes1
answer458
viewsSave Excel file to Python via Scrapy
As I do for mine Spider save all Excel data in a single XML file links which I extract? Or also save in each single XLS file in the project folder? Part of my Spider: def parse(self, response): divs…
-
0
votes0
answers247
viewsConvert an EXCEL file to PDF using php
I’ve got a lot of loose ends, and I need some help getting me on the right track. I think it will not be too difficult, thank you and the rest of a good week, Diogo Pereira. Here is the result show…
-
0
votes0
answers1066
viewsHow to change the CSV file field separator from ',' to ';'
I am developing a utility to transform XLS and XLSX files to CSV, but I would like CSV files to come out with semicolon separator instead of comma, here is the code: # -*- coding: iso-8859-1 -*-…
-
0
votes1
answer44
viewsHow to resolve Invalidformatexception in xls file generated by Jett?
I have a way of generating reports done with Jett: Map<String, Object> beans = new HashMap<String, Object>(); beans.put("fichasTecnicasMateriaPrimaResumo",…
-
0
votes2
answers356
viewsSetting parameters and filtering file . TXT
I have a file with a tab | in file . txt, would like to turn it into file .xls and then work with it by filtering and replacing values in python3. And possible ?! Follow a template of the file ".…
-
0
votes1
answer135
viewsRead certain columns of xls file in Python with XLRD
I am a beginner in language and I am trying to display the contents of a spreadsheet on the front end with Python. With this code I am displaying the result of the columns name, surname, city and…
-
0
votes0
answers11
viewsCapture only one line of an Excel spreadsheet with POI
Hello, everybody! I have a system that needs to validate the type of cell contents of a spreadsheet line. I wish it was just a line, to avoid going through all the lines in the file, to avoid…
-
0
votes1
answer35
viewsThere is no error in the execution of the code, however the return I am having in the excel table is that is the problem
I have a problem returning my code. I do not get any error in the execution, but the problem is the return in the Excel table. I’m doing a case study of my college and the system is about customer…
-
-1
votes2
answers74
viewsFind a string inside a python list
Hello I have a spreadsheet xls and a XML where I read this information and my goal is to find information from XMl inside the spreadsheet for this I am using the method IN more can not find THE XML:…