Questions tagged as 'excel'

Tagged questions
2
answers

Place an image in PHP excel With an external path

I have the following code to insert an excel image, which works correctly: $objDrawing = new PHPExcel_Worksheet_Drawing(); $objDrawing->setName('imgNotice'); $objDrawing->setDescription('Noticia');...
asked by 01.03.2017 / 17:46
2
answers

How do I change cell values in a range with a "Yes" formula

I want to change the 'values' cells I13 to K13 , that is I13 J13 K13 by means of the formula "Yes" when the value is true.     
asked by 24.11.2016 / 04:18
1
answer

How to handle a variable date within a loop

Problem I take data from an excel xls document (use jxl libraries), the data goes to text, and the dates must be converted to YYYY-MM-DD. But when I read them with the application, it takes them in the following way (length of the date v...
asked by 22.08.2016 / 05:49
2
answers

Excel Conditional Format

Good morning, I am creating a spreadsheet with a form to be able to document the status of an order. Depending on the status, the cells from A to N have to change color, additionally for certain status such as "CI ERROR / TICKET", the color of t...
asked by 13.10.2016 / 04:50
1
answer

How can I know if a date is a date? (VB.NET)

My intention is to know if the data that the user has entered, is date and that it is in the MySQL ( YYYY-MM-DD ) format. First I made a query with data type date to a table of Excel , but it turns out that when doing a test to see what...
asked by 16.08.2016 / 00:51
1
answer

Read the .xlsx file with PHPExcel

I'm trying to read the cells in my xlsx file with PHPExcel but I can not get it. require_once('Classes/PHPExcel.php'); require_once('Classes/PHPExcel/Reader/Excel2007.php'); $objReader = new PHPExcel_Reader_Excel2007(); $objReader->setRe...
asked by 04.08.2016 / 17:01
1
answer

import xls with rich text, with phpExcel

I am looking for a way to import an xls with rich text to the server database through phpExcel. Some cells in the file contain plain text and other rich text, with several formats in the same cell. I have already checked the option getStyl...
asked by 19.07.2016 / 14:06
2
answers

EPPlus Exception from HRESULT: 0x8003001D (STG_E_WRITEFAULT)

How to access an Excel file using EPPlus? The code seems to be fine .. ViewBag.Message = "Cargar Almuerzos"; byte[] file = System.IO.File.ReadAllBytes(@"C:\MENÚ DEL 09 AL 13 DE MAYO.xls"); System.IO.MemoryStream ms = new Sys...
asked by 13.05.2016 / 14:43
0
answers

customize Excel exporter

Good I have this function that I use to export to excel. function ExportToExcel(tabla) { var clone = tabla.clone(); var trs = clone.find('tr'); $.each(trs, function(i, tr) { $(tr).find('td:eq(13) li:nth-child(1)'...
asked by 11.12.2018 / 18:44
1
answer

Visual Basic Excel - Create Folders using 2 columns

I am new to Visual Basic 6 and I have a problem. I need to create folders using two columns, that is, in each folder I have to appear the contents of A1 and F1 separated by a low script, for example, and so on. Searching forums and YouTube...
asked by 09.12.2018 / 22:30