Questions tagged as 'excel'

Tagged questions
0
answers

How to capture text from a textarea in vba?

I'm maintaining a program that maps a site through ids, updated the site and I'm changing the ids, but I got a part that has a textarea and I have to get the information that is inside it, and I do not know how do that. the part of the code is t...
asked by 08.11.2018 / 13:56
1
answer

Save excel file to an array

In the example below I have a class in java that will fetch data from a certain excel file. All this part of fetching the file the program does, but now needed that this data be stored in an array. I do not know how to do it. public class UniF...
asked by 26.10.2018 / 21:15
1
answer

Excel "Add-on" function, does not add the total of two distinct items in relation to the list?

I used the "Add product" function to add the total of products 1 and 2, but the result of zero, I wanted to sum the total of the values of only two products in the list, but only works by adding only one, as I do to apply the sum only in product...
asked by 26.10.2018 / 17:55
1
answer

JXL generate excel sheet with decimal value in Brazilian standard

I'm using Java and Jsf on my system and there's a screen where you have the option to generate an excel spreadsheet. The generation of the worksheet is ok. The problem I'm encountering is in columns that have numeric values of type Double. For e...
asked by 26.10.2018 / 19:16
1
answer

Copy rows and paste based on a value in an excel cell

I would like to know how I can copy a set of lines. For example, line 1 through 5 and paste in lines 10 through 15. This action would be done with value 1 on another sheet and in cell A1. I have a button with VBA to do this, but I wanted to d...
asked by 01.11.2018 / 17:30
1
answer

Excel - Insert values into text

Good, I am creating an excel where I would like to insert values (in function) into text. I want to pass values from Column F12 to H12. I want to enter text here where it says [here] UPDATE public_ads SET ads_price = [aqui] WHERE ads_re...
asked by 28.10.2018 / 12:55
0
answers

How to insert color formatting through a formula in Excel?

I have two cells with characters with different color formats, but when using the Concatenar function and other functions to extract the characters in another cell, the color format does not apply as defined in the two cells, same colors...
asked by 25.10.2018 / 17:35
0
answers

Problems with Excel file generation (.xlsx) with the PhpSpreadsheet library

I'm working on a project where I need to generate Excel files with bank information (reports). I was able to do this with the PhpSpreadsheet library, however the file is saved on the server, and when I add the headers to force the file to be...
asked by 24.10.2018 / 01:08
1
answer

IMPORTHTML on Google Sheets with error

I'm trying to create a file to grab Alexa's Audience Geography area / table data ( link ) but google sheets whenever I try to pull an error appears. =IMPORTHTML("https://www.alexa.com/siteinfo/twitter.com";"//*[@table='demographics_div_country...
asked by 05.11.2018 / 14:50
1
answer

Sleep function or Wait locking worksheet in Excel

I'm programming a macro in vba, which makes the connection to a sql server database and makes a select in a table and returns me the time of the last change in the database. I created a program in vba that takes the system time and makes a calcu...
asked by 17.10.2018 / 22:04