Questions tagged as 'excel'

Tagged questions
2
answers

Empty rows with OpenXml Excel

I'm going through an excel with the library DocumentFormat.OpenXml , and when I get the rows, I get rows in which the cells are empty; that is, I have an excel where you only have information in the first 10 rows, but you are extracting in...
asked by 05.02.2016 / 20:28
1
answer

How to import excel data considering the first row that do not have a header in C #?

To be able to import data from excel I use the following code: Foldername = Server.MapPath("~/Importados/"); fileuploader.SaveAs(Foldername + filename.ToString()); String conStr = ""; switch (Extension) { case ".xls": //Excel 97-03...
asked by 01.08.2018 / 06:54
1
answer

How to insert a new row with data in an Excel spreadsheet

I am looking for help in a code that is complicating me a lot since I must use (at least I think so) the Range method. Find , which I have not managed to know how it works. What I need is a code with which you can enter new blank rows in an...
asked by 11.07.2018 / 17:40
1
answer

Insert data from EXCEL to a table in SQL SERVER

I have a sheet in Excel 2016 that contains several columns with information about my clients; the file path is "D: \ Clients.xlsx". Then I have a table "tb_clients" in the Database "bd_comercial" (SQL Server 2008 R2) with the same names, orde...
asked by 21.05.2018 / 00:00
1
answer

Multiply two variables that contain ranges

I am trying to multiply two variables (be ContractsQty and LeaseQty ) to get the total of lines that have to be created. I'm trying to use something like this: 'Calcular cantidad de lineas Dim ContractsQty As Range Set Contract...
asked by 16.01.2018 / 20:46
1
answer

Problem when downloading .xlsx in Chrome Error: network error

When I want to export a list of type IEnumerable from Chrome it gives me an error that says "Error: network error". I try it in Firefox and it's ok, download the file. Someone will know how to solve this, or have an alternative (another method t...
asked by 25.01.2018 / 23:09
2
answers

Problem special characters excel - html

Good morning. I'm passing the contents of an excel to a table, by showing me the table data the special characters appear with a . The excel is in xls format. PHP code require_once ("Excel/reader.php"); $datos = new Spreadsheet_Exce...
asked by 17.06.2017 / 10:25
3
answers

Memory error when importing data in MySQL from an Excel excel file

This is receiving the following error: Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 2 bytes) in C:\xampp\htdocs\servisa\Excel\reader.php on line 482 I have to read a very large Excel file (13 mb, 9...
asked by 12.04.2016 / 00:18
0
answers

SMART TAG EXCEL

Good day, I turn to you guys because I need help! You will see in Office 2013 Professional I do not see the list of actions, and without the action DATE (XML) a file (XLBS) created by our reporting team does not work. The truth I would lik...
asked by 29.08.2018 / 15:15
0
answers

How to save the exported table to excel with a name?

I am using the following code to export an html table to excel, and it works perfectly, but the file saves it with the name of "download" and what I want to know is is there a way to save the excel file with the name that I want? var tableToEx...
asked by 18.05.2018 / 00:53