Questions tagged as 'excel'

Tagged questions
1
answer

Format fields with Laravel-Excel

The following code allows you to export a .CSV file using the maatwebsite / laravel-excel library from Laravel 5.2 . Excel::create('Filtro Productos Concentrado', function($excel) use($ini, $fin, $gr) { $granjas = Granja::all();...
asked by 09.04.2018 / 21:46
0
answers

I need to export an NVARCHAR from JAVA in excel

I am using the sql server database in which I am using a cursor. I need to read this NVARCHAR from java so I can export it in excel from java. Take into consideration: that these columns of my Excel will be added more in the future. e...
asked by 09.03.2018 / 20:43
1
answer

Help to export this data

Hello, I wish you a good day, the thing is this ... I currently have this code for a button Private Sub btnfiltrar_Click() On Error GoTo ErroresIf Me.txtfiltro.Value = "" Or Me.txtfiltro.Value = " " Then Me.ltbdatos.Clear Else Me.ltbdatos....
asked by 22.02.2018 / 15:17
0
answers

Wordpress plugin generates excel file

I am creating a plugin in wordpress that should download an excel with several data from the DB but instead of doing so, paste the table into the Wordpress dashboard. <?php /** * Plugin Name: Excel * Plugin URI: http:// * Description:...
asked by 24.01.2018 / 17:45
0
answers

how to copy data from one column to another openpyxl?

Dear, I am working with openpyxl and I need your help I want to copy the data from the A - B column to the C - D column but that the B data is divided by 10. and A's data is as is. How can i solve this? the other steps and I have them I...
asked by 22.12.2017 / 03:57
0
answers

EPPlus 4.1.1 Error CS0103 when creating ExcelPackage

I'm getting this error when creating ExcelPackage and I can not find why.    Error CS0103       Unable to find the requested value 'baseline'. " var info = new FileInfo(RutaArchivo); using (ExcelPackage pck = new ExcelPackage(info)) // E...
asked by 14.12.2017 / 19:25
0
answers

Amcharts Export Plugin does not download the data correctly

The problem is when I set a time range and try to download the data in .XLSX format that feeds the Amcharts chart. According to a 2-year query should be 19 columns (Fixed) and 24 records corresponding to 24 months, when opening the downloaded...
asked by 24.11.2017 / 21:28
0
answers

Error vb.net import excel to DataGridView [closed]

I am doing an import of data from an Excel spreadsheet to a datagrid on VB.net Something I managed to do, if I assign the DataTable to the DataGrid. But what I really need is to move field to field from the spreadsheet to the DataGrid. To...
asked by 25.10.2017 / 16:07
0
answers

Problems reading excel (xlsx)

I have a problem that I have never had when reading an xlsx file, I explain what I'm trying to do. I have a script placed in a cron that downloads the attachments of an email account and then reads the information from the files and saves them i...
asked by 27.10.2017 / 17:56
1
answer

Protected View in Excel with GX 9

I am generating Excel files from GX9 - java. The Excel version is 2013, Win 8. If they are generated on my pc, all Excel files open with "Vista Protegida" red level. In the same application there are other procedures that generate Excel spreadsh...
asked by 12.10.2017 / 15:50