Questions tagged as 'excel'

Tagged questions
0
answers

(1/1) FatalErrorException Class 'Rap2hpoutre \ FastExcel \ FastExcel' not found

Hello everyone I have a problem with the fast-excel library in laravel 5.4 .. in my local version it works without problem but in the server I get the following error.    (1/1) FatalErrorException Class 'Rap2hpoutre \ FastExcel \ FastExcel'...
asked by 08.12.2018 / 01:56
0
answers

Read Excel and pass it to a datatable keeping format

Dear, I have a query, I am trying to read an excel but the file is corrupt with a specific format but I do not have an office installed on the server, so I have to read it with closed xml and pass it to a datatable (For that reason I can not ins...
asked by 05.12.2018 / 14:03
0
answers

Extract data from SAP to Excel. Error 619

I have recorded a sequence in SAP, and I have passed the code to the Excel developer. In that sequence, the only thing I intend to do is to open a query about it when opening the Excel workbook. I do not have the loop implemented to get all the...
asked by 27.11.2018 / 10:33
1
answer

VBA I have trouble calling a range that is on another page of my book

I wanted to do it in the following way: Selection.FormulaR1C1 = Application.Goto (ActiveWorkbook.Sheets ("TRANSFERS"). Range ("RangePara")) What I want is that the selection that I currently have is with the values of the dynamic range t...
asked by 23.11.2018 / 17:39
0
answers

How to import data from an excel file to asp.net core 2.1 mvc and then store it in a sql server database with C # language?

I am new working with asp.net core and the tutorials I find now to import or export are for version 2.0 which includes web forms, but from version 2.1 the web forms were no longer incorporated. Thank you in advance.     
asked by 22.11.2018 / 17:38
0
answers

Connect SQL Server with Macro in Excel

on this occasion I want to request your valuable help. I have a stored procedure with 3 parameters in SQL and I need to create a Macro in Excel with 3 text fields that will feed the parameters. Then, I must collect the result of the Execution of...
asked by 22.11.2018 / 23:38
0
answers

How to obtain data from a website withExcel

It turns out that I need to obtain the data from an excel page, I could already do the first part that was to send the data to consult the page with excel vba the code I used was this: Sub obtenerDatos() Dim IE As InternetExplorer...
asked by 21.11.2018 / 20:54
1
answer

problems when inserting new data to excel using datatables

I do not know how to explain my problem very well. I have never known how to do it with certainty. I will start by showing you my code where I ask the user to enter the following information: Name, last name, age and sex. These data will be s...
asked by 21.11.2018 / 20:51
0
answers

How to configure Excel / Wndows / Browser to export military date

When exporting reports from a web application, using Internet Explorer (it must be with that browser) to an excel * .xls file (the application has the predefined option as well) one of the date and time fields in some PC's exports as follows "11...
asked by 20.11.2018 / 16:53
0
answers

Save excel in Database with PhpSpreadSheet

PHP code, which verifies if the folder exists and then reads the Excel data. The problem that I have is these are students and at the time of printing they print 1 to 1 for example: the name is printed, then the last name, etc. Nose how to put t...
asked by 20.11.2018 / 21:25