Questions tagged as 'excel'

Tagged questions
0
answers

How to pass the name of the Excel worksheet (s) to a JList [closed]

I would like to know how I pass the names of worksheets from an excel workbook to a JList when I click a button. Since I already have the button created and it simulates a shell to locate the file. Taking advantage of the topic, can I capture...
asked by 24.06.2016 / 14:28
1
answer

LaravelExcel is converting the header values of an excel spreadsheet. How to disable this?

I'm using the LaravelExcel library to import data from an excel into a database. To get the header data from my worksheet, do the following: Excel::load('file.xls', function($reader) { $nomeDasColunas = $reader->get()->first()-&...
asked by 25.07.2016 / 15:53
0
answers

How to find the ID of input fields (Texts and Listbox)?

I ran the code below and was able to identify the field ("body_x_tabc_x_identity_x_prxidentity_x_selBscenCode_x_txtselBscenCode_x_x") via the Set objInputs line. But I can not identify the other fields. Among them there are also listboxes. Det...
asked by 28.04.2016 / 21:34
0
answers

Files with .XLX extension of excel converted to .xlx.crypt extension on my desktop where saved. What to do? [closed]

Files with xlx extension in excel have been moved to .xlx.crypt. I think you got a virus. Would you know how to remove and not lose the files? Thanks for the help in advance     
asked by 25.05.2016 / 22:50
0
answers

Identification of a VSTO solution

I've implemented a Excel Workbook project in Visual Studio. The project runs right, my problem is how to install this on the client computer. I do not want a ClickOnce installer, because the add-in should start every time the client open...
asked by 28.01.2016 / 17:08
1
answer

Error trying to create Excel table with ClosedXML

I'm trying to create an application that generates a spreadsheet in Excel through Visual Studio 2015 using ClosedXML as a reference. As I found some examples on the web, I added the same to the code (using ClosedXML.Excel;), I downloaded the ref...
asked by 04.03.2016 / 19:33
1
answer

How to read an excel file in a console application in C #?

I am trying to read a data from an excel table in C #, my code looks like this: string resp; string rota= "D:/Users/e608871/documents/visual studio 2010/Projects/CEMIGID/CEMIGID/CEMIGID.xlsx"; var excel = ne...
asked by 20.10.2015 / 13:22
0
answers

Generate chart in Excel - C #

Hello, I would like to ask a question: I am exporting the generated data in a gridview to Excel, and at the same time I am generating a Graph in Excel itself from C #. I would like the chart size to increase dynamically according to the size of t...
asked by 28.11.2015 / 15:17
0
answers

ReportViewer - Data merge columns when exported to excel

I am generating a report and exporting to excel using ReportViewer and DataSet. The ReportViewer consists of a table and two textbox , which refer to the title and company, and an image. After doing some tests it was found that the% w /...
asked by 02.10.2015 / 19:36
1
answer

How to export ReportViewer to Excel while maintaining field types?

I have a report in ViewReport in VS2010 and when I export to Excel, the default VS button does not retain the fields format. This way I can not use Excel functions like SUM for example because all the fields are like Text. Has anyone ever had...
asked by 30.07.2015 / 15:50