Questions tagged as 'excel'

Tagged questions
1
answer

List Codes from a Certain Vendor in Excel

I have a Product Table with Code and Vendor. I would like to know how I can in the vendor table list all the codes for a particular vendor. Can I do this only through formulas in Excel? Example below:     
asked by 13.10.2018 / 21:32
1
answer

ScreenUpdating x On Error GoTo ErrorHandler

With the code below: Application.ScreenUpdating = False Application.EnableCancelKey = xlDisabled On Error GoTo ErrorHandler 'Código Exit Sub ErrorHandler:Application.ScreenUpdating = True 'Código caso erro End Sub ScreenUpdating = False...
asked by 21.10.2018 / 02:48
1
answer

How to "kill" a class in VBA - Excel

I have a code that calls a Private sub which in turn erases the data from a worksheet. If I do the same procedure without closing the form it gives error at the time of erasing the data, however if I create a new sub with another name and the sa...
asked by 19.10.2018 / 19:07
1
answer

How to paste a dataframe on a preformatted worksheet in Python?

I have a preformatted template in Excel that way. I would like to paste values from a dataframe into the pandas on these cells, creating a new file formatted with values and holding the original file. How do I do this?     
asked by 16.08.2018 / 19:41
1
answer

How to add content to the Excel VBA ListBox

Hello, I have a question in a code for Excel VBA. I want the code to search the worksheet for the same number that was typed in TextBox , after finding it, sends the information from the entire spreadsheet to ListBox . Since the code...
asked by 15.07.2018 / 03:37
1
answer

Search for a sub-string in the first column of a csv file

I'm starting to learn in python and I do not know how to proceed with this code. I need to check the first column of a csv file, and if it does NOT have a date in a cell of that column, insert the one that was passed as a parameter. import...
asked by 20.06.2018 / 19:37
1
answer

Compare first characters of two distinct columns in excel

Is there any function in excel that allows me to compare the first n characters of text I want? Por exemplo Tenho a palavra Joaquim e Joana, comparo por "Joa" e ele me retorna verdadeiro ou falso.     
asked by 25.09.2018 / 16:12
2
answers

Changing the CSV Delimiter in Python

I'm having a difficulty in the cell delimiter of the CSV file, when I command the save the edited file in CSV % with% delimiter by default is escritor.writerow([linhas]) , plus I need change to , because when I open the file in Ex...
asked by 27.03.2018 / 14:35
1
answer

How to read data from an excel table in C?

I know how to read data and write to .txt files with C code through fscanf(), fprintf() functions and so on. But now I would like to know if there are C functions or libraries that allow me to treat data from a excel table,...
asked by 28.03.2018 / 14:37
1
answer

Automatic Classification with tie-break criterion

Good afternoon, using the automatic sorting of excel, is it possible to create levels and sub levels? For example, I am creating a soccer spreadsheet and I want to sort first by scoring and if there is a tie, the one with the highest goal balanc...
asked by 13.03.2018 / 20:18