Questions tagged as 'excel'

Tagged questions
0
answers

Popup Preventing Macro from Moving Forward

I have a macro that enters a particular site, populates a form, and sends save to the system, generates a request. After that, a popup is issued with an "OK" button. This ok has eventClick that ends the process and restarts the cyc...
asked by 15.03.2018 / 15:15
1
answer

Export HTML table to Excel while retaining styles

I would like to know how to export a table from my html code to excel while maintaining the formatting (colors, borders, etc). I am using the following function: <script type="text/javascript"> function fnExcelReport() { var tab_tex...
asked by 09.02.2018 / 01:41
1
answer

How do I set the filters in a PivotChart through a macro in Excel?

I made a VBA form and wanted to click on a button for the filter properties of the PivotChart associated with a table in Excel to change.     
asked by 17.01.2018 / 12:21
1
answer

How to close an alert in IE in with VBA

I have an Excel macro that connects to a local tool and extracts the information. Basically I take a report according to the user. I have a column with the users, however if the user does not present results in one day the tool triggers an alert...
asked by 26.02.2018 / 19:34
0
answers

MySql for Excel

I make the connection to the DB, loads but when editing the folder is password protected. I tried to put the DB code and nothing. Has anyone had this problem, could I give a help?     
asked by 26.01.2018 / 11:45
0
answers

Error opening excel generated in php

I have a system that generates forms for the client, and when it fills in this automatically saves an Excel with the data, but when I go to open Excel appears the error: O formato de arquivo e a extensão de 'Nome do arquivo'.xls' não correspon...
asked by 22.12.2017 / 10:37
0
answers

C # Asp.Net.MVC - How to read Excell worksheets (xls and xlsx) using NPOI and generate a datatable?

I would like to read an Excel worksheet (XLS and XLSX) in my C # application, using the NPOI library and generating a DataTable. Since I have never used this library, could anyone give me a practical example?     
asked by 22.12.2017 / 14:03
1
answer

Save Graph of a spreadsheet in a folder by VB

Hello everyone. I am a beginner in VB programming and I am with a project, where I access a worksheet and I enter data in it and this data is shown in graph. How do I save this chart as an image in a folder and then use that image? It's possible...
asked by 11.01.2018 / 07:40
1
answer

Automatically leave dates in order

How do I leave my table that has dates organized in order, type, has the cells: date of issue; name; due date; situation, I wanted my table to be organized by expiration date automatically when I put a new value, either by clicking a button or w...
asked by 30.12.2017 / 16:23
1
answer

Copy columns of corresponding rows

I have a spreadsheet that contains 100 lines with country names and 12 columns (months of the year) containing values. My need is to compose a macro that: sweeps the columns and copies them to another worksheet so that the country stays in colum...
asked by 22.11.2017 / 17:00