Questions tagged as 'excel'

Tagged questions
1
answer

Returns Excel in List C # is returning null

This code reads a Excel file and throws a list, the problem that is occurring is it is returning null , as if there was nothing in it Excel , but the column names are correct: string PathConn = "Provider=Microsoft.ACE.OLEDB.12...
asked by 01.10.2014 / 17:18
1
answer

Merge data from different tabs into one in Excel

I have 18 worksheets (tabs) with user data and I need to copy and paste the data into another worksheet (tab) in the consolidated name. I need to copy the header only from the first worksheet and at the end remove the empty lines. It's all in...
asked by 14.06.2018 / 20:15
1
answer

Filter PivotTable by ListBox

Private Sub Filename () .. From this post here Filter PivotTable by Word in a Cell ... It is very efficient in searching the column A .... I would like to get the values that are in the Listbox and apply them as filters in TD ... (Act...
asked by 21.06.2018 / 22:49
1
answer

Return in a DataFrame - Python

Good afternoon. I have a question regarding Python. I have an if where has the conditional and else, the else it processes more than one file and I need to save all the information it reads inside a DataFrame, is there a way to do this? The c...
asked by 22.05.2018 / 20:43
1
answer

Formula Excel - Apache POI

I created an excel file using the Apache Poi API, in it I set one of the cells with a formula, but when I open the file I need to "enter" in the cell with the formula so that it will print the result in the file. Would there be a way to make thi...
asked by 10.11.2017 / 17:19
1
answer

ComboBox does not update and accepts wrong values

Well, I have this code for a combobox, and I have two problems. First: I can not get the combobox to just accept the list values Second: Listing only has value PrivateSubTempCombo_Change()DimvAsVariant,iAsLongWithMe.TempComboIf.Value&...
asked by 13.07.2017 / 18:34
1
answer

C #: How to identify worksheet title

Hi, I'm working on an excel-to-txt converter and I've been trying to make an algorithm where it detects the column title and returns an error if the column had the same title, to identify only the title? In this algorithm it only compares the...
asked by 03.07.2017 / 17:34
1
answer

Turn multiple columns into one

Hello, I do not program VBA and I am not able to make a code that would do the following: |A |B |C | ---------- |1 |6 |11| |2 |7 |12| |3 |8 |13| |4 |9 |14| |5 |10|15| My table has several columns like these up there, I would like you to h...
asked by 22.09.2016 / 17:31
1
answer

Error opening excel file exported in PHP

I use the following code: <html xmlns="http://www.w3.org/1999/xhtml" lang="pt-br" xml:lang="pt-br"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport...
asked by 23.06.2016 / 01:34
1
answer

How to import data from the internet to excel vba

I'm trying to download a site's table: " link , and I've already" got it ". But there's a problem with my code. I want the user to set the team. This is done by selecting in a combo box on the site, well, I even change the combo box data, howeve...
asked by 31.12.2016 / 21:59