Questions tagged as 'xls'

Tagged questions
0
answers

Remove duplicates based on the value of a column

I'd like to know how I can perform the following filter: ===> Thatis,howtoremovetheduplicatesinthe"action" column, but leaving the record with the highest priority (in this case, '1' is the person with the highest priority and '8' is the...
asked by 21.05.2018 / 22:21
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
0
answers

Create an .xls file

Good evening. I have some doubts about xls (I know nothing about it) and I have some issues. can anybody help me? Here's the first one, which asks you to create an .xls file that will check if the temperature is greater than 20 and then remove t...
asked by 17.01.2018 / 00:02
1
answer

Synchronize MySQL database with XLS

The situation is as follows. I have a MYSQL database and an XLS file on an FTP server The code below downloads XLS to read and UPDATE from the database from the XLS data. The problem is that it only updates the existing data, I need to check...
asked by 06.01.2018 / 00:01
0
answers

Read .xls file

I have a problem reading a .xls file 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 = wb['Tab 1'] for row in ws.get_squ...
asked by 04.10.2017 / 04:30
1
answer

How to solve InvalidFormatException in xls file generated by jett?

I have a method to generate report made with jett: Map<String, Object> beans = new HashMap<String, Object>(); beans.put("fichasTecnicasMateriaPrimaResumo", fichasTecnicasMateriaPrimaResumo); try { InputStream inPath = Produt...
asked by 04.09.2017 / 17:53
0
answers

Import .xls into node.js

I need to import a .xls file and save the data to an api. I would like to know a simple way to do it. The logic is to throw that data into a array and make a POST with each line? In short, I want the user to click on a bu...
asked by 21.12.2016 / 15:21
0
answers

Convert an EXCEL file to PDF using php

I have a lot of loose ends, and I need some help to get me on the right track. I think it's not very difficult, thank you and rest of a good week, Diogo Pereira. Hereistheresultshowinthebrowser,whichwillbetopasstoPDF. Andhereisthexlsfiletha...
asked by 23.09.2016 / 10:27
0
answers

Generate 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 one, it follows a brief excerpt from the code: // Primeiro Arquivo for($i=0;$i<1;$i++){ $html[$i] .= "<ta...
asked by 08.09.2016 / 23:55
1
answer

Problems with .jar generated with jxl library [duplicate]

Hello! I am having problem in the generated .jar file of a project. In this project is included a library, called jxl responsible for reading and writing .xls files, but it is returning the following error when clicking a button that calls a t...
asked by 18.11.2018 / 17:27