Questions tagged as 'excel'

Tagged questions
2
answers

insert records from an excel file to a DB MS access delphi

I'm doing a program that imports Excel into the database, This is my code: var importdir, ipo: string; begin if OpenDialog1.Execute then begin importdir := ExtractFileDir( OpenDialog1.FileName ); ipo := OpenDialog1.FileName; end; ADOConnection...
asked by 10.09.2018 / 23:22
1
answer

Save several DataFrames with a for loop in different sheets of the same excel file

I would appreciate your help, I have the following code: for embalse in ["PIL", "PUL", "VDV"]: vo = pd.read_csv('...\Desktop\pucv.xlsx',encoding='utf-8') vo=vo[vo["Embalse"]==embalse] writer = ExcelWriter('...\Desktop\embalses.xlsx...
asked by 11.09.2018 / 20:26
0
answers

Send data in WS SOAP Service with VBA Excel

I'm trying to make a macro in VBA in excel to send a request through a Web Service SOAP service, I managed to create it with the following code confirming that it actually works: Sub erp_automatico() Dim sURL As String Dim sEnv As String Dim x...
asked by 08.11.2018 / 03:25
0
answers

Update to an SQL Column with Excel inormation

I'm really not sure how to attack this problem. I have a users table: id nombre dato 1 juan 1a 2 pedro 2b 3 paco 3c An Excel document with the name document : A 1 01a 2 02b 3 03c My intention is that through a PH...
asked by 22.08.2018 / 17:08
0
answers

Is it possible to save excel workbook in vsto c #?

I am looking for how to assign the option to save workbook to a button. as the image Try this but it does not save the current workbook, it only generates a new one. var saveDialog = new SaveFileDialog() //create new instance of s...
asked by 07.08.2018 / 18:53
1
answer

Value of columns per row of excel java

I'm trying to get the values of the cells that form a row of an excel document. The point is that I recover all of them in a row but I would like to recover the value of a specific cell. I put the code here. Thanks in advance. public void l...
asked by 11.06.2018 / 23:28
1
answer

How to add Header to an Excel Report with PHP

I need to generate a report in Excel with Cabecera, that is, add who did it, the department, the time I downloaded the excel from the page. etc ... etc ... I already generate the report, but I have no idea how to add the other. This is the f...
asked by 23.05.2018 / 13:21
0
answers

how to export images from php to excel

Hello, I already have a file that exports me a table to excel but this table contains images which are not exported. Somebody could help me. I urgently need a solution to solve this problem. This is my code to export but not the image <?...
asked by 14.05.2018 / 15:57
1
answer

How to define an Array in VB excel with a range?

Good morning community. It turns out that I am looking for a way to filter, that allows me to select several references to filter, that is, by means of a macro I indicate to my Excel file that I look for a client by reference number. Examp...
asked by 18.06.2018 / 22:26
0
answers

Odoo11. Send view to Excel

Currently working with Odoo 11. I have the following case: Suppose we are in the Contacts view, any user can configure this view in their own way, add filter, group, and in this way create a customized view of the information they want to...
asked by 28.04.2018 / 16:40