Questions tagged as 'excel'

Tagged questions
1
answer

Drop-down list with repeat criteria

I have a conference list, where in Plan1, column A, only the codons that are in Plan2, column A, will be typed, but with a criterion, only the total number of times in plan2 can be repeated. > To enter in Plan1, only the cods of Plan2 I use...
asked by 30.08.2014 / 03:09
1
answer

Macro to automatically fetch images and play in excel

Good afternoon, I have a spreadsheet, where I need to automatically include images. I would like to know if there is any way to create a macro, where you merge the Reference and the color (reference & color) and search in a certain folder the...
asked by 10.04.2018 / 19:48
1
answer

Check the number of copies that were printed

Hello, I have a table that, when printed, generates a record in a txt, telling the user who printed it, which machine, which printer, which document, and when. But I would like to also record the number of copies, but I have no idea how. Code...
asked by 29.06.2017 / 18:41
2
answers

Sum of intervals

I needed a formula to calculate values with intervals. That is, I have several levels:    Between 0 and 5 = 0.58 €;       Between 6 and 10 = 0.64;       Between 11 and 15 = 1.05 €;       Above 15 = 1.46 €. If the number is 7 for exa...
asked by 15.12.2018 / 01:13
0
answers

Update data (Excel) [closed]

I have a problem related to external data in excel This is an example of what I have done: Index (Book) Painel (sheet) - I enter data in the panel that will be sent to another book (count) sheet (sum) and will receive the data c...
asked by 06.01.2016 / 13:24
1
answer

How to save an XLSX (Excel) file instead of CSV?

Today I have the code below, which saves a file in CSV format. What do I need to change to save in XLSX (Excel) format? public static void buildCSV(string filename = "resultado.xlsx") { Console.WriteLine("Escrevendo no a...
asked by 30.11.2018 / 22:23
2
answers

How to check the name of the Excel C #

How to check the name of the "Sheet" of the Excel worksheet before performing the% pro SQL ? My code so far: protected void btnProcessar_Click(object sender, EventArgs e) { string path = Server.MapPath(".") + "\" + FileUp...
asked by 15.08.2016 / 18:32
1
answer

Formula excel SOMASE

I put this formula in Excel and it did not work, why? =SOMASE(E2:E158;"<=4>=10";B2:B158) I can not put it that is greater than 4 and less than 10, it only accepts one of two hypotheses ... how to do?     
asked by 27.05.2015 / 19:23
1
answer

Questions about VBA / Excel executable program generation

I compiled a VBA program that interacts with an Excel spreadsheet. After no more crashes pointed to when compiling, compilation is performed and no action is presented at the end. I did not find the executable program in any folder (if it was...
asked by 01.04.2016 / 02:53
4
answers

Dynamically setting the Excel column size

I'm working with the generation of spreadsheets in EXCEL, and for this I use the standard api of the framework. Imports Microsoft.Office.Interop.Excel However, when I have a column with very long text, the line is broken with each word or a...
asked by 23.04.2014 / 14:01