Questions tagged as 'excel'

Tagged questions
2
answers

How can you export csv file with asp.net c #

Good I would like that I can be doing an application for which has the functionality to download a file in File Format of values separated by commas Microsoft Excel (.csv) already defined the columns in that file once you download the user wit...
asked by 22.09.2018 / 19:33
1
answer

Import an Excel table to phpmyadmin while maintaining text formats

I want to import an Excel table to phpmyadmin keeping italic and bold formats. (I've got everything I need except to keep the text formats). I have the following: Through a form the client inserts the Excel file With phpExcel I scroll t...
asked by 15.07.2016 / 18:00
1
answer

Read excel with a large number of columns in C #

Hello dear developers, I have a small problem, it turns out that I am reading excel sheets in a console program and I play an excel that has a lot of columns (Until the column ABT) and my excel dataset only reads up the column WZ and I do not kn...
asked by 12.11.2018 / 20:07
2
answers

Can you convert Excel tables to a mysql database? [closed]

I would like to know if there is any way to convert Excel tables to MySql. Thanks     
asked by 24.11.2017 / 10:14
1
answer

Error SQLSTATE [HY000]: General error: 1366 inserting CVS with PHP Mysql?

I have a page that lets you import CVS to Mysql database, but when in the CVS there is a symbol that occupies 4 bits instead of 3, I get this error: SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\x96 0014...' And the impor...
asked by 27.04.2017 / 11:39
1
answer

Export Access to Excel Report

I apologize I have a report in access with a format in the headers of the columns, and hypernicule fields, when exporting to excel I export it without format, how can I do the export respecting the format that I have. Thanks     
asked by 12.03.2018 / 19:12
1
answer

generate excel in java and download it from jsp

What I'm grabbing is generating an Excel file in java from a query in sql the file is generated by clicking on a generate report button that I made in jsp and the idea is that when the Excel is generated I get the option of downloading that file...
asked by 09.02.2017 / 20:41
1
answer

can not execute in break mode

I'm trying to run the following code Workbooks("book2.xlsx").Sheets("Sheet2").Range("A8").Value = "D2" and he says:    can not execute in break mode Does anyone know what happens?     
asked by 11.11.2017 / 21:28
2
answers

Excel POI cell in bold

Good that such They know what is the method to put the text of a cell in black to apply the style from java with the class poi Thanks and a greeting. HSSFWorkbook a = archivoexcel(); HSSFSheet hoja = a.createSheet("LOGS"); int longitud...
asked by 04.06.2018 / 14:06
1
answer

Bold parentheses (Visual basic)

I was wondering if there is an option in Visual Basic that marks in bold the parenthesis that you are closing as many other IDEs do, since it is easy to get lost without this help THANKS     
asked by 08.08.2018 / 20:31