Best answeres tagged with excel

1

answer

How to export a Datatable to Excel without formatting the information?

I need to export a number to Excel, but it always formats in an inappropriate way. Expected form: -8,0902322222234 Received: -809.023.222.222.234 Column data for Datatable is typed with string. Data is displayed in...

asked by 02.01.2016 / 00:14

1

answer

VBA - SQL - Filter with SELECT

I would like help with extracting information from another worksheet through SQL. The link on the worksheet where you will establish the connection and extract the information is this: Google Drive The link to the spreadsheet where the D...

asked by 17.11.2018 / 23:00

2

answers

Export to excel via javascript, put name in file

> function ExportToExcel() { var htmltable = document.getElementById('exportdata'); var html = htmltable.outerHTML; window.open('data:application/vnd.ms-excel, ' + encodeURIComponent(html));...

asked by 13.12.2016 / 22:20

2

answers

Is it possible to transfer MySQL data directly to a table in Excel?

Is there any way to transfer all the information from the database to a table in Excel? It can be in any language.

asked by 17.09.2015 / 04:09

1

answer

Generate header when exporting data to excel

I did an export routine for excel , using StreamWriter , but it gives me a problem. I can not get the name of the columns that come in the select. For me to do the header, I had to put it in the hand. This would not be the problem, t...

asked by 12.01.2016 / 11:21

2

answers

Failed to connect to MySQL via VBA

I'm trying to connect to a Mysql database via Excel VBA, but it returns an error reporting catastrophic failure. I did a test by entering the wrong password, or the wrong database name, and it informs that access was denied or the database does...

asked by 12.12.2014 / 12:50

1

answer

Save files from a DataGridVIew

I would like to know how do I get all the content that was passed to a DataGridView and save it to an Excel file. So far I have this: private void btnDiretorio_Click(object sender, EventArgs e) { folderBrowserDialog.RootFo...

asked by 17.12.2014 / 14:39

2

answers

Export charts from an Excel worksheet without Interop

I need to read and write data from Excel spreadsheets, and export some graphics, using C #. But I can not use the interop library ( Microsoft.Office.Interop ) for this. How can I do it? Does anyone have any nuGet package indication for...

asked by 03.12.2018 / 15:14

1

answer

VBA - Backpack problem

asked by 05.02.2014 / 18:49

4

answers

How to transport data from R to excel?

I calculated a series of data in R and would like to know which command I should use to move them to an excel spreadsheet.

asked by 26.03.2014 / 19:55

Questions tagged as 'excel'