Questions tagged as 'excel'

Tagged questions
1
answer

An exception of type 'System.OutOfMemoryException' occurred in mscorlib.dll but was not handled in user code asp.net

I'm having trouble getting this error resolved. My purpose is to collect data from an Excel file storing it in C # variables, which in turn will be inserted in SQL Server 2012. Reading is done line by line. Here is the code where the error happe...
asked by 24.02.2017 / 10:50
0
answers

Display image in Excel using binary code

I have a report on Excel where data is displayed through stored procedure . I have a problem because when I look for the value of the image field that is blob , it displays the binary code in the report instead of the image...
asked by 09.01.2017 / 02:56
1
answer

Cell selection

I need to select the line with the value of combobox 1 and the date of combobox 3 to select the desired line to delete. This is the problem I have to solve. Can someone help me? This is the code I have to select the cell of combobox1: Pr...
asked by 25.05.2017 / 17:04
1
answer

Consolidate macros

I need to create a macro that allows me to choose all .xml files and import them into excel. At this point the process is as follows: - I open the first one manually and then call the macro that imports all the others selected. I would like to k...
asked by 26.08.2016 / 21:46
0
answers

How to inherit a form in VBA?

I need to inherit a form in a VBA project to use as a basis for other forms. For example, a form called " Table " contains a list of two columns and buttons for ' Edit ', ' Include ' and ' Delete ' items; and whenever you make use of tables...
asked by 15.05.2016 / 19:54
1
answer

Message "Compile error" (Loop without Do)

I do not understand why I've put Do Until! Private Sub cmdPequisar_Click() 'Verificar se foi digitado um nome na primeira caixa de texto If txtCPF.Text = "" Then MsgBox "Digite o CPF de um cliente" txtCPF.SetFo...
asked by 28.06.2016 / 21:11
0
answers

Format excel cells via code behind

I have a routine that generates an excel spreadsheet from an Oracle database. What happens is that in BD I have values like this: 3456.90 or 1900.00 When these values arrive in the worksheet, it looks like this: 3456,90 or...
asked by 14.01.2016 / 18:15
0
answers

How to import Json data from a table into Excel

I want to generate charts with Chart.js and need to import data from an excel spreadsheet to json in order to draw the chart. var data = { labels: ["January", "February", "March", "April", "May", "June", "July"], datasets: [ { labe...
asked by 07.04.2016 / 15:18
1
answer

How to delete / delete repeated lines comparing different cells?

I want to know how to delete a line that is repeated throughout my table. The image below may help Possible solutions: 1. Scroll through the Macro of file Excel1 to pass the data to the file Excel2 . Avoid insertin...
asked by 04.03.2016 / 16:30
0
answers

Find values with part of text [closed]

I have one problem, I have a spreadsheet . Now I can do the search by name, but I wanted to type only part of the name, for example, instead of typing "Raquel", I type "Ra" he already bring me Raquel, Rafael, Raimundo, etc ... With this form...
asked by 19.01.2016 / 10:42