Questions tagged as 'xls'

Tagged questions
1
answer

Export XLS content in WordPress admin

I need to export specific content to XLS within the administrative area, and I'm using the following code: $arquivo = 'planilha.xls'; $html = ''; $html .= '<table>'; $html .= '<tr>'; $html .= '<td colspan="3">Planilha teste&...
asked by 15.07.2015 / 00:39
0
answers

Genexus X Ev. 3 - Problems reading Excel (xls)

Hello, I'm having a problem reading xls, just loading it and it appears at the bottom of the browser "Waiting for localhost (or the server)", I did the xlsx test with normal runs. I have tested in other browsers and other machines with differ...
asked by 06.06.2018 / 14:43
0
answers

Missing Task SrcSet0 (Loading) in source MICROSOFT_EXCEL ODBC

Hello, I'm trying to set up oracle data integrator to read an excel spreadsheet in xls and xlsx formats, but I'm having problems and I can not find a solution! it returns me the following error: IconfiguredODBCinthisway: Andtestingthesepara...
asked by 27.12.2017 / 12:48
1
answer

Importing XLS to PgAdmin

I'm trying to import a spreadsheet with information from a database table, but when I try to import, it gives the following message:    field 'md5' must have a value However, there are values in this field. I do not know what to do about...
asked by 10.12.2017 / 23:18
1
answer

save to file a backend return

My backend controller returns a file of type xlsx to my front, this is the method that returns: public FileResult ListarLivrosExcel() { // Gerando minha planilha e recebendo-a using (ExcelPackage arquivoExcel = new BmpoDTO...
asked by 20.02.2017 / 11:37
1
answer

Save Excel file in Python through Scrapy

How do I make my spider save in a single XML file all the Excel data from the links that I extract? Or do you also save in each single XLS file in the project folder? Part of my spider: def parse(self, response): divs = response.xpa...
asked by 14.05.2018 / 20:53
1
answer

Apache POI: how to tell if a spreadsheet has come to an end?

I'm developing a personal project, and for this I'm using Java along with the Apache POI to read XLS files, how can I tell if the spreadsheet has come to an end? Thank you!     
asked by 10.02.2018 / 04:23
3
answers

Edit an XLS file already created

I need to edit an XLS file already created, but I'm only able to create a new file and delete the old file, so far it works, but I wonder if you can edit the old file and not have to delete the old one and create a new one with the same name....
asked by 21.09.2016 / 14:29
1
answer

Exception when reading excel file using apache poi

I'm trying to read an Excel (XLS) file using the Apache Poi API, and I'm taking the exception : java.io.IOException: Invalid header signature; read 0x0020000A000DFEFF, expected 0xE11AB1A1E011CFD0 - Your file appears not to be a valid OLE2 docu...
asked by 11.07.2014 / 14:57
0
answers

How to change the CSV file field separator from ',' to ';'

I'm developing a utility to convert XLS and XLSX files to CSV, but I would like the CSV files to come out with a semicolon instead of a comma, here's the code: # -*- coding: iso-8859-1 -*- import glob import pandas as pd excel_files = glob.gl...
asked by 11.10.2018 / 18:47