Questions tagged as 'excel'

Tagged questions
0
answers

Use SUMPRODUCT to add cells that in turn have VLOOKUP formulas and it does not work. It gives me zero

I have an Excel with 3 sheets (operating system in English): On the DATA sheet I have data correlation tables. To know what month is month 1 I have this: - Cell D2 = 1 - Cell D3 = January On the DATA ENTRY page I have this: - In cell I1 I...
asked by 25.07.2018 / 16:41
1
answer

Error trying to export a jTable to excel

I'm making a code for the generation of an Excel file of jTable , however at the time of executing it I mark this error and I do not know how to remove it    Exception in thread error "AWT-EventQueue-0"   java.lang.NoClassDefFoundError:...
asked by 17.07.2018 / 16:12
2
answers

Why does not my excel document come out the same as the JFrame?

This is the Jframe and this is the excel What can I do to make Excel the same Jframe? this is my code import java.awt.BorderLayout; import java.awt.Color; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; im...
asked by 11.07.2018 / 17:34
1
answer

Help with epplus formulas (Excel) c #

I'm doing an excel in which I made some formula, but when I take a cell that is the result of a formula, to use it in another formula it shows me in the cell literally the formula. As it is highlighted in the colors yellow is the range...
asked by 28.06.2018 / 22:13
0
answers

perform a filter and execute it according to a button

How can I make a filter that, according to the press of a button, shows me the results as shown in the image according to the range "ai1: al217" ?, but I would like it not to be filtered in the 4-digit numbers with the x     
asked by 28.06.2018 / 22:19
0
answers

Save blank column in Excel CSV

I want to import an Excel CSV file into my database with phpMyAdmin. It turns out, that my table has to store 4 different fields. id , codigo , nombres , apellidos where: id: Is the ID of the table as a primary...
asked by 02.07.2018 / 18:59
1
answer

what can I change, when loading an xlsx to excel and if a cell has: 'mark error

good day. I already have the page created and I upload my excel files to mysql using php, all right up there but when cell has the sign of ' There is an error when inserting or updating the table. Excel files send them to me, I adapt them to m...
asked by 23.06.2018 / 03:39
0
answers

Formula concatenate excel in c #

I'm applying a concatenation formula using the excel tools for c #, the formula I'm trying to apply is to concatenate Code C # Sum_RangeResuTot.Formula = "=CONCATENATE('LA SUMA ES',SUM(F" + (i + 5).ToString() + ":F" + (i + 15).ToString();...
asked by 23.06.2018 / 03:01
1
answer

delete repeated words in 2 different cells

I'm stuck making a sheet in which I want to delete a series of words that I have in 2 different cells. En la celda A1 tendría GLUTEN, SOJA, En la celda A2 tendría SOJA, GLUTEN, SESAMO, PESCADO, I would like to get in a 3rd cell, A3: SÉSA...
asked by 26.06.2018 / 11:05
0
answers

Error: The form to import excel dynamically (.csv), (.xlsx). It does not work for me

I am trying to incorporate this form to import csv or excel files into my system. I was guiding myself from other web pages. Import the css and js files. But it's not working. I get this error in the console:    [Deprecation] Synchronous XMLH...
asked by 15.06.2018 / 20:43