Questions tagged as 'excel'

Tagged questions
2
answers

How to do a mapping from an Excel column to a database column

I needed help to do the specific mapping of a column from an excel file to a column in a database. I can read the excel file but I just can not map the file to the column I want in the database. If you need any part of the code just ask like any...
asked by 10.10.2017 / 13:22
1
answer

Data type mismatch in criteria expression + Excel data manipulation

Analyze to see if the logic is consistent, please. The procedure for this code is: Query a procedure and store its data in DataTable : private DataTable ExportPerformanceEntrega() { try { String...
asked by 05.10.2017 / 14:35
1
answer

Resetting the counter every time you change lines

I have the following problem: I have two counters in my code, but I want every time I move to the next line, the contLine1 (second counter) is zeroed and start counting again, remembering that there are 32 columns when it comes back to 1 of the...
asked by 15.09.2017 / 20:01
2
answers

Read .js file and write to page using javascript

I have an Excel spreadsheet that I want to export some data to load into an HTML page. Searching the net I found that this is only possible if I have this data in a .JS file (data type .js). So far so good. But how to read the data in the .js...
asked by 28.09.2017 / 19:46
1
answer

C # excel column format

I'm trying to format an excel column for the currency format. excelWorksheet.Range["S1", "S" + linhas].NumberFormat = "R$ #.###,00" However, this causes you to format "RR $ 3500.00". In the cell is 3500 and I would like it to be:...
asked by 17.07.2017 / 15:26
1
answer

How to handle EXCEL with PHP?

How do I manipulate cells from excel with PHP? For example: I need to get 2 cells in different rows Cell 1: AB2 Cell 2: BC4 And multiply them AB2 * BC4 =? And print this value on the screen. All this in PHP, but how? File type: CSV...
asked by 29.06.2017 / 13:19
2
answers

Excel VBA delete item from ListBox

I'm having trouble deleting an item from a listbox . The code works like this: it will have listbox with the list, and when the user wants to delete an item, it clicks a button that opens another userform , in that userform...
asked by 03.05.2017 / 16:30
2
answers

Generate an excel file from a data grid C #

I'm trying to generate an excel file from a datagrid, and this is generating the following error: Anunhandledexceptionoftype'System.InvalidCastException'occurredinEletronicTaxNotes.exeAdditionalinformation:TheCOMobjectoftype'Microsoft.Office.In...
asked by 02.05.2017 / 15:44
1
answer

Painting cell with conditional formatting using SE [duplicate]

I wanted to know how to paint the cell phone of a certain value: For example: I have the salary of $ 100 in cell A1 In cell B2 is the sum of my bills So in cell C1 I would paint in red if the bills went over $ 100 and green if it did not go...
asked by 03.06.2017 / 15:57
1
answer

Auto complete when typing any part of the word

How can I autocomplete text by typing any part of an information within the ListBox using VBA? Example: When you type in "Santos" all options containing this word will be listed / displayed in the listbox.     
asked by 10.05.2017 / 14:55