Questions tagged as 'excel'

Tagged questions
0
answers

Fatal error: Uncaught PHPExcel_Exception: Cell coordinate can not be zero-length

When I try to create a function that fills my data automatically with PHPExcel and a series of fixes, I get the following error:    " Fatal error: Uncaught PHPExcel_Exception: Cell coordinate can not be zero-length string in C: \ inetpub \ w...
asked by 04.12.2017 / 18:37
1
answer

Openpyxl - SyntaxError: invalid character in identifier

With the following script I try to get the data from a range of cells: wb=openpyxl.load_workbook('testfile.xlsx') sheet = wb.get_sheet_by_name('Hoja1') # Imprimir un rango multiple_cells = sheet['A1':'C20'] for row in multiple_cells:     for...
asked by 15.12.2017 / 20:39
1
answer

how to recover a VBA module and userform in excel after closing

I've been working on an excel file with a userForm for weeks, right now I saved it and when I closed it and opened it again (a few minutes later) the macro that opened it told me that the macro could not be executed, it might not be available or...
asked by 10.12.2017 / 09:23
0
answers

Generate excel in C

Good morning, I'm trying to create a library to generate excel files (.xls) in C, but I have no idea how to get sheets, here's the code: #ifndef SACAEXCEL_H_ #define SACAEXCEL_H_ //cada celda ira separada por una '\t' de la siguiente y por...
asked by 25.11.2017 / 14:53
0
answers

Show Hyperlink to SQL to Excel

I have searched everywhere like activating a hyperlink obtained from SQL to Excel. Example: SELECT '=HIPERVINCULO("http://example.microsoft.com/informe/"; "Haga clic para ver el informe")' I connect Excel with sql and it brings me the re...
asked by 05.03.2018 / 21:40
1
answer

get the value of the last day of the month

I have a very long table of dates and values in excel A B ------- ------- 1/1/17 10 3/1/17 7 31/1/17 6 6/2/17 6 15/2/17 6 23/2/17 98 3/3/17 25 13/3/17 5 31/3/17 18 I need to find the values in column B for th...
asked by 23.11.2017 / 16:24
2
answers

Start process in the background with C #?

I've been trying for a while, but I can not execute excel in the background. What I want is to do a service that opens an excel book every 30 seconds and closes it later. static void Main(string[] args) { while (true)...
asked by 13.11.2017 / 15:25
1
answer

Error downloading awesome table files

Good evening; I write to see if the error is by the browser or is common in these cases. I'm developing a view using awesome table view, which allows you to interact with googlesite with googlesheets and allows you to download the filters wit...
asked by 13.11.2017 / 02:58
0
answers

Edit Excel cells with Visual Studio C #

I try to make a program to read and write cells of an Excel file and I am following a small tutorial that I found. The case is that at the time of adding the references; microsoft.visualstudio.tools.applications.runtime microsoft.office.intero...
asked by 15.11.2017 / 10:27
1
answer

Can you import data from an "Excel" to multiple tables? (Related tables)

I have a question, I want to upload an excel file and that this amount the information obtained. I upload it, but I do not know the form or the method (If it exists) to upload the file in several tables (It is a giant format, but it is normalize...
asked by 06.11.2017 / 16:17