Questions tagged as 'excel'

Tagged questions
0
answers

Error accessing the defined names in an Excel using Interop

I'm doing a program in C # (Visual Studio 2015) from which I have to update an excel that has a series of formulas, etc. I have decided to use Interop instead of other libraries like open xml or epplus because I need to update certain fields...
asked by 17.10.2018 / 11:34
1
answer

Problems when exporting DataTable to Excel

using System; using System.Net; using System.Linq; using System.Data; using System.Net.Mail; using ClosedXML.Excel; using System.Collections.Generic; namespace Productos_Sin_Parametro_Ax { class Program { static void Main(string[]...
asked by 16.10.2018 / 16:39
1
answer

How can an error be solved: "Could not find the installable ISAM file?

public static void ROC_ExcelToDatagridView (DataGridView dgv) { path = ""; try { try { OpenFileDialog file = new OpenFileDialog ( ); file.F...
asked by 13.10.2018 / 00:04
0
answers

Export DataGridView using Epplus c #

I would like to know if anyone has a guide on how to export a DataGridView (c #) to excel using EPPLUS, and been looking for some guide in Spanish, but nothing appears in this regard. Or if you can give me an example here to export it, it wou...
asked by 12.10.2018 / 23:37
0
answers

How to pass the data from an xml to excel using Vb.Net?

Good day, The problem is that when I read the data of my xml, it does everything without problem, but when trying to send the data to an excel, it overwrites the data and only pulls the data of the last xml that read . Help. Imports System...
asked by 10.10.2018 / 23:05
0
answers

Change the origin of the data of an existing Excel chart using VBA

I have an existing graphic, called GRAFICO_PARETO. This graph has a data origin, for example let's say from A1 to G20, and I have to change it for a different range, but not from the Excel front-end, but from vba. The code that I have tried is:...
asked by 10.10.2018 / 14:57
0
answers

Why do I get an error when trying to assign a value to an excel column using the interop library?

I want to generate reports with the information of the BD, in fact everything is fine except when I want to start adding the information I get inside the excel. Excel setting code: ExcelCreate.Application excelApp = new ExcelCreate.Applicat...
asked by 05.10.2018 / 18:07
0
answers

Error using Application.Evaluation

I am using this instruction to try to find out if a cell has conditional format or not to be able to apply one format or another. I do it with this code that I put below, seen as an example on other websites, and it gives me an error of type 13...
asked by 04.10.2018 / 20:19
0
answers

excel 2016 + serial port

I am trying to make a program that communicates with a device through the COM3 port using vba. But there is no way for excel 2016 to have a serial port. It is urgent and important I would appreciate help please. Thank you very much.     
asked by 04.10.2018 / 17:10
0
answers

how to update the database from an .xlsx file with JSP and MySQL?

The problem is that I am working with JSP connected to MySQL . I want that on the page where my database table will appear an update option and when clicking on update, a navigation window will open and you will have to search where that file...
asked by 27.09.2018 / 22:25