Questions tagged as 'excel'

1
answer

Overwrite an Excel file with Java and Apache POI

Very good. I have created an application that receives a date and writes an excel file with necessary information to fill data in a dynamic table in excel. The class so far creates the file without any problem, but, I would like to know if I...
asked by 04.07.2017 / 19:51
1
answer

SAS or VBA excel sort data from left to right respecting column headers

I am trying to sort data as descending by row but to respect the names of the columns to show first the column with the highest value in the first month, and so on with all the lines of the month. I know that the first one prevails. It is what i...
asked by 15.06.2017 / 15:39
0
answers

COMBOBOX: Unidentified object error or variable with not established

I have a form that when starting must fill certain ComboBox, I have problems with some in particular, which are filled from a function that invokes data from SQL SERVER. The issue is that when I put the Call llenarInstrumentos(cmbCVinstr)...
asked by 30.06.2017 / 20:18
0
answers

Copy 2 rows once found a different value

I would like to copy the values from A to D: (2 rows of values per date) to another sheet For example copy the values A2: D2, A6: D6, A7: D7, A13: D13 .... I'm new to programming. I managed to find when the date changed, but then I g...
asked by 09.07.2017 / 11:57
1
answer

Read a column in Excel

Good afternoon, how can I read a specific row-column? For example, I only want to read two columns in specific, D8 up to D15 and G8 up to G15 . If you could guide me or if they had the code, it would be useful, than...
asked by 03.06.2017 / 00:20
0
answers

The format and extension of the "file.xls" file do not match

When I save a file from angularjs with a content and save it to an excel file. I get that message in excel and I can not find the solution because for more headers I add is still coming out, some indicate that it is by the kb link others that...
asked by 23.05.2017 / 15:02
0
answers

Extract data from Internet Explorer to Excel

Good day. I'm programming a macro that will extract information from a Table in Internet Explorer and upload it to an Excel sheet. So far I have only managed to extract the headers from the table but I have not managed to get the content....
asked by 12.04.2017 / 16:55
0
answers

How to upload an excel file that is in a folder contained in the same path of the .exe?

I am developing a WFA that is used as a database based on an excel document (.xlsx), the content of the document provides the database of information with which the user works, currently the program works without any problem when the user manu...
asked by 10.04.2017 / 03:49
2
answers

insert text at the beginning and enclose the values of one column in excel to another

The problem I have is given a column1 to pass the [dynamic] data to column2 with the following conditions: a) quote with quotation marks each data from column1 to the column2 and that the first data is added to the parenthesis at the beginning...
asked by 05.04.2017 / 22:42
1
answer

generate excel in shiny

I created the following program in Shiny with which I pretend that by clicking on the "Generate Excel" button I can download the excel. But in doing so I get an error in which it tells me that it can not find the file. Does anyone know wha...
asked by 06.04.2017 / 14:30