Questions tagged as 'excel'

Tagged questions
1
answer

Can you space two texts in centimeters in the same Excel cell?

As shown in the figure below. I need to tabulate in a single cell two texts so that from one cell to the other (from the same column) the texts on the right are perfectly aligned (see column D). Intheupperpartofthefigure:exampleoftheresultth...
asked by 18.03.2017 / 14:24
1
answer

Excel VBA - How to use VLookup with Letters and Numbers to Delete Rows?

Hello! I'm experiencing great difficulty with a problem using VLookup in Excel VBA. First of all, I am not VBA expert but I have been able to use VLookup but I am not having the effect I would like. I will explain below with more detail the situ...
asked by 07.02.2017 / 15:59
1
answer

Import workbook from another worksheet into a new workbook in the current worksheet

Using the example passed on Microsoft MSDN, the following error appears:    Run-time error '9': Subscript out of range VBA Code: Sub Principal() Dim PathName As String Dim Filename As String Dim TabName As String Dim C...
asked by 18.03.2017 / 23:42
0
answers

Tab in excel

Hello I have a spreadsheet with some data on federal revenue imports. About this worksheet I make a tabulation of data, based on one of the columns that comes in this worksheet called "product description", from this column I check the informati...
asked by 19.02.2017 / 17:01
0
answers

Extracting two information via Selenium and pasting into only one cell in excel

I'm trying to extract some web information Via selenium, the point I'm catching is this: I can direct information from the selenium searched on the internet and save it inside a specific cell, however what I need would be, that in a query two fi...
asked by 19.12.2016 / 20:45
0
answers

Problems using the PHPExcel cache system with Laravel 4.2

I am trying to use the PHPExcel library cache system , however I am still getting memory overflow in my application. I need to use cache because I am generating reports with more than 100,000 records on a server with limited memory. Therefore...
asked by 06.12.2016 / 19:27
1
answer

fmBackStyleTransparent does not work in Excel VBA

I have a VBA issue with Excel , and so I looked at other users as well and have no answer so far, like this link. BackStyle property = fmBackStyleTransparent does not work It happens that the property no longer works in the current, o...
asked by 28.10.2016 / 03:02
1
answer

How to add a value to DBF

To read the .DBF file work as follows: I use a TADOConnection, ConnectionString to: Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq=C:\_workspace\projects\DBFEditor\temp To read the DBF file I use a TADOQuery setting the SQL...
asked by 19.10.2016 / 18:45
0
answers

Compare field values of two excel tables in different files

I have two tables in 2 excel files, and I want to compare each value of column A of file_1 with each value of column A of file_2 and still each value of column F of file_1 with each value of column H of file_2. If there is equality in both cases...
asked by 03.11.2016 / 18:31
0
answers

Get data from a PivotTable in Excel

I'm trying to read from an excel sheet and I'm creating a PivotTable programmatically and it's working fine, however I'm having trouble picking up this filtered data because it does not return all of the items that have been filtered with more t...
asked by 07.10.2016 / 21:19