Questions tagged as 'excel'

Tagged questions
0
answers

Is it possible to import only files with similar names to a worksheet with VBA?

I have several worksheets in separate excell files, and I need to insert the data of each of the worksheets into a specific region of a table, which will perform the analysis of the received data generating a final result. Theprocesswouldtak...
asked by 29.03.2018 / 00:22
0
answers

How to select an item from a listview and change its information in the source cell (where the data is entered into the listview)

I'm having a difficulty on a Form, in which I have information from a plan1 (Database), plan2 (Support for the dynamic filter). Where Plan1 gives me the information about the listbox items, and plan2 serves to work with the filter with several c...
asked by 26.03.2018 / 17:44
0
answers

Problems with openpyxl. Open Excel file with Python

I'm trying to read an Excel file but this error message appears. Warning (from warnings module): File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/site-packages/openpyxl/reader/worksheet.py", line 318 warn(msg) UserWa...
asked by 20.03.2018 / 05:54
1
answer

How to export mysql table to table in excel

I have a nice system where the user registers on one page and sees another. However, the user of this system wants to be able to export this table which is exactly my table in the database to a giant Excel tab that it has. I have no idea h...
asked by 08.03.2018 / 15:08
0
answers

How to edit cells from an excel file from the npm xlsx library

I'm exporting some json files to excel, and it's working perfectly, however I wanted the document to already be styled with font color, bold in the header, the link to documentation is: link , I do not know if I am very inexperienced but with t...
asked by 05.03.2018 / 15:54
1
answer

Vba + Google Chrome

I have been doubting for some time and even after several searches I did not succeed. I'm creating a function in VBA that can handle a webpage using Google Chrome. Although I set the chrome as an object, I can only send "sendkeys" commands to th...
asked by 02.03.2018 / 21:20
0
answers

Problems with OPENROWSET in SQL Server 2016 Express (64bit)

Good morning, I'm trying to read an Excel .xls file by the OLEDB driver used in SQL Server for integrations with Microsoft.ACE.OLEDB.12.0 files in SQL Server 2016 Express (64bit). Using the command OPENROWSET but I'm getting the famous er...
asked by 02.03.2018 / 14:57
1
answer

How do I install a library (PHPExcel) in an application with codeigniter using NPM?

I'm developing an application that needs to export data from an array that received the result of a query in Excel format dynamically, and I wanted to know how do I import the library, started studying the web last semester and resumed this year...
asked by 27.02.2018 / 18:31
0
answers

openpyxl generating corrupted workbook

I'm getting some data from MongoDB and sending it to Excel. I'm using openpyxl but some workbooks show the following error when I open them:    "we found some problem with some content in excel ...". Could anyone help me? Code: ws =...
asked by 26.02.2018 / 11: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