Questions tagged as 'excel'

Tagged questions
1
answer

HSSFWorkbook - How to copy one worksheet to another? [closed]

I have an excel worksheet that I need to copy some data to another worksheet. This old spreadsheet is like a "base", I need to copy only the header and caption part (with the style of the cell, in addition to the text). I'm using the HSSFW...
asked by 05.09.2017 / 20:21
1
answer

Image with time interval - Excel

I need to assign an image that appears every 1 hour in EXCEL, how ?! You will probably need to use VBA. But I'm not very familiar. And you close by yourself after 1 minute.     
asked by 27.10.2017 / 15:15
1
answer

How to bulkcopy an excel file into an sql table

I wanted to bulkcopy an excel file into an sql table. But it's giving me this error when I try to send to sql:    System.InvalidOperationException: 'The specified ColumnName' TransDate '   does not match any column of data source. ' The co...
asked by 30.10.2017 / 12:09
1
answer

Day function Excel Dates does not work

I do not know what to do, excel does not show me the correct result in the date formula below, the expected result should be 30 days but appears 1/30/1900     
asked by 05.10.2017 / 16:54
1
answer

Separate equal, odd, and equal numbers in matrix by VBA (Excel)

How to make a 10x10 matrix, separate odd and even and odd without Mod?     
asked by 04.07.2016 / 01:07
1
answer

Select an option that is only possible by mouse click with vba

I'm trying to develop a script with vba, in excel , to facilitate a routine we have at work, which inserts about 9,000 data into the internal system. We are currently manually inserting this data. This data will never be the same since it is...
asked by 13.06.2016 / 04:20
2
answers

Excel move non-duplicate values between two columns to a third

I have a question and I can not get a plausible answer. I have a worksheet in which I would like to make a comparison between two columns and say to it that if there is a value that is not duplicated, that same value is moved to a new column. Fo...
asked by 04.03.2016 / 02:23
1
answer

Excel Formula to look up part of the text in a table

I have a table of banks and codes in two columns. Ex: Banco do Brasil S / A 001 Bank of the State of Rio Grande do Sul - Banrisul 041 Banco Santander do Brasil 033 Banco Mercantil do Brasil 208 Banco Itaú S / A 341 Some expr...
asked by 06.04.2017 / 15:05
1
answer

Excel file reading

I'm trying to use C # to read an Excel file, but every time I run the code the last column is not stored Reading Code: //Cria conexão com a planilha OleDbConnection conexao = new OleDbConnection(@"Provider=Microsoft.ACE.OL...
asked by 07.01.2016 / 21:06
1
answer

Formula - receive values from one cell range to another, except empty cells

I have a range of cells containing empty cells and some not, arranged in a row and I need a formula that receives those values in a column, except the empty cells, below an example of what I need, adding that the said ranges are named "BlanksRan...
asked by 11.01.2016 / 11:40