Questions tagged as 'excel'

Tagged questions
1
answer

VBA - excel does not recognize external data comma

Good morning everyone! I'm trying to integrate excel with other software (the EES - Engineering Equation Solver) through vba code. My program copies certain columns from a table, transfers to the other program, performs the calculations, co...
asked by 15.07.2015 / 15:58
0
answers

Filtering PivotTables in VBA

I have two PivotTables and I want to always select the same item in them, which in this case are names. So I have a rule that picks up the names in another worksheet and the number of pending issues, if the person has more than 20 issues, it sho...
asked by 30.06.2015 / 13:28
0
answers

PHPExcel - Library automatically converts date notation when importing Excel worksheet, from dd / mm / yyyy changes to mm / dd / yyyy

I'm going through a problem that is already making me bald .. In a certain part of an application, I need to import user data through an Excel spreadsheet, so I'm using the PHPExcel library. However, when I edit the information in Ms Excel...
asked by 21.07.2015 / 15:46
0
answers

How to insert image in xsl worksheet with php? Is it possible that the database is saved only the path of the image in a folder on the server? [closed]

What is being passed to the worksheet is just the path of the image, but I need the image to be passed to the worksheet. The image that is in the server folder, and only the image path is saved on the server. <?php header( "Content-...
asked by 01.07.2015 / 20:36
0
answers

Logically help with a system that writes data to Excel columns

I have an application and I can pass the data quietly to excel, the problem has arisen now because I have to make a loop and I can not find the best way to do this. I have several lots, for example 1,2,3,4,5,6,7,8. Each lot has several customers...
asked by 30.04.2015 / 16:47
1
answer

Manual filter via VBA with the latest values available

I need to filter, via VBA, the last 30 values available in a dynamic table but in the "manual filter" which is the line ... Is it possible to read the values in the "manual filter" in VB?     
asked by 25.03.2015 / 19:46
0
answers

Web Pages - Show, assign and search data in an Excel file

I've created a WEB page to work as a FAQ in SharePoint 2010 . But I do not have much knowledge either in SharePoint and neither of HTML and JavaScript . I'm researching to get more knowledge about the topics. On my page I hav...
asked by 23.03.2015 / 13:07
1
answer

PROCV - How to avoid window to select external worksheet when none exist

I have a planilha that uses data access of lookup of other planilhas PROCV , but they are floating formulas, that is, they change according to the entry in specific fields. This change occurs through Macro , wh...
asked by 23.04.2015 / 22:01
0
answers

Contacts page Completed through Excel

I am creating a web page and would like to know if what I want is possible. I have a page that contains contacts <tr> <td>Teste - 123456789</td> <td>Teste - 987456123</td> </tr> This several times and som...
asked by 13.01.2015 / 16:29
4
answers

How do I search if column A values do not exist in column B?

For example, I have a spreadsheet: [ A ] [ B ] 1 valor1 valor1 2 valor2 valor2 3 valor3 valor3 4 valor4 valor4 5 valor5 valor6 You can see that in column B, valor5 does not exist, what I wanted was...
asked by 14.09.2017 / 21:17