Questions tagged as 'excel'

Tagged questions
0
answers

How to activate the paragraph marks in Excel 2013 to visualize the end of the CRLF line in a * .csv file?

I need to activate the paragraph marks in Excel 2013, in word I already identify how to do it, adding this functionality to the ribbon. But in Excel I did not show the option Display (Display) to be able to activate the visualization. Could some...
asked by 04.10.2017 / 23:26
0
answers

Select a variable range in VBA

I have a table on an Excel sheet. I need to select and assign to a matrix a variable range that depends on two variables: Start Dia and DiaFinal . The first column of the table is a date field with this format: dd/mm/aaaa; This ta...
asked by 22.03.2017 / 14:01
1
answer

Data Source on PowerApp

Is it possible to make several Excel (in One Drive ) as Data Source for my PowerApp . That is, in One Drive I have several Excel with logs of each day of access: One file per day, a new file will always be generated, and the dat...
asked by 20.03.2017 / 15:50
1
answer

Perform AutoFill or FillDown on a filtered column. Excel VBA

Good morning, The problem I have is the following. After making a filter with criteria other than N / A, I am placed in the first filtered cell to perform a VLOOKUP. This operation is performed perfectly, the problem is as soon as I want to d...
asked by 23.01.2017 / 14:32
1
answer

Update in Excel using ADODB from VBA

I can read the data of an Excel in a shared folder using a Recordset with ADODB ; I can write that data in a local file, but in the form Range().Value . I could not do it using a Update with ADODB . This is my...
asked by 10.01.2017 / 21:55
1
answer

How to maintain the style and format in excel from python

Hello, good night, everyone. I'm working on a project with Excel and Python. In this case I have to make some modifications to an xlsx file. But this file comes with a certain format and style in each of its pages. The problem I'm having when sa...
asked by 17.02.2017 / 05:01
2
answers

Edit an excel file by means of C #

I want to edit an excel file, similar to an invoice, fill in the fields of the columns with the data in the textbox that I place, when I click on a button (Generate Fact.), I open the file with the data already added in the fields....
asked by 09.01.2017 / 23:43
1
answer

Export Excel does not write all the data

I have a process that exports me the information of a Resultset to a normal excel file that works well with 500 to 600 records, but if they go beyond that number of records, I do not write all the information, that is, it omits a lot of data....
asked by 29.11.2016 / 01:45
2
answers

Do Merge of data to EXCEL Documents?

Good day, it happens that I need to make a functionality that modifies some fields that are defined in an excel document in JAVA just as I am doing it at the moment with word documents (.docx), the truth is that there is an API but I have no ide...
asked by 04.11.2016 / 21:30
1
answer

Error using openrowset

I have a problem regarding openrowset . I am running the following encoding: SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 12.0;Database=C:\Procesos\PRUEBA.xlsx', [Hoja1$]) and I get the following error:    The O...
asked by 05.11.2016 / 00:44