Questions tagged as 'excel'

Tagged questions
1
answer

Export DB to Excel

Well, I'm doing a data recovery from my bank to Excel, it's working perfect so far, so it's having a limit, it's not making the impression of my whole table! So getting the 2,800 initial users and there are more than 9k could you help me? Cou...
asked by 21.06.2017 / 17:31
1
answer

How to change the Excel document icon [closed]

I want to change the excel document icon, to have another face and look like an executable, or something, can you help me?     
asked by 20.06.2017 / 09:35
1
answer

Export tabbed text in Excel

Hello I need to generate a text file based on this layout to be imported into a system. I'm trying to use Excel, I create the cells with the appropriate sizes as the layout asks. In Excel I go to "save as" and I choose: "Formatted text (se...
asked by 08.06.2017 / 12:12
1
answer

Summarize data in Excel without VBA or PivotTable

Sorry if this question has already been answered, but I'm not even getting the question to do the proper search. I have a list of products sold in excel, and I need to select the top three products on the list. Until then, you could use the "...
asked by 09.05.2017 / 17:37
1
answer

Export an array of data from matlab to excel

I have a file with multiple arrays, as described: Name Value lat <162x168 single> lon <162x168 single> obsData <162x168x4929 double> time <5844x3 double> v6Data <162...
asked by 28.04.2017 / 19:31
1
answer

C # Oledb truncating column excel

I'm doing a select in an excel where I have an observation column (open text). The problem is that on some lines it truncates the contents of that column by bringing only one part. try { conn = new OleDbConnection("Provider=Microsoft.ACE.O...
asked by 10.04.2017 / 22:40
1
answer

Export SQL query data to Excel

Good afternoon guys. I created a database to control receipt and delivery of cards. The inclusion of the data is done through a form in excel. This form also has the option to query existing data. the query returns the information in the f...
asked by 30.03.2017 / 17:29
1
answer

Error #VALUE! when using IF operation

I have this table in Excel and in column E I have the following expression: =IF(AND(SEARCH("qwe*";B:B);SEARCH("qaz";C:C));TRUE;FALSE) I do not understand why it should appear FALSE to see the #VALUE! error. -b143-c08a24dbe812? ui =...
asked by 17.05.2018 / 15:13
2
answers

Generate PivotTable in Excel from MSSQL with 8 million records

I have a table in MSSQL with currently 8 million records. I use Pentaho to analyze this data. I'm trying to use Excel too. If I set it to get the data and put it directly into the PivotTable, it does not restrict the 1 million records, becaus...
asked by 27.01.2017 / 17:41
1
answer

Save results from a query to an array

Good afternoon! I need to get the results of this query: sql = "SELECT controle.ID FROM controle WHERE BP = '" & controlectform.nmbpbox.Value & "';" And save to an array. Subsequently I will do a for each in that array and I will...
asked by 03.04.2017 / 21:40