74 questions
0
votes
0
answers
156
views
R code for reading Excel in character format
I am trying to open an Excel dataset in R studio, exactly how it looks in Excel, so I can learn how to manipulate it in different ways within R studio, rather than doing prep via Excel first. I am ...
1
vote
0
answers
114
views
Unable to Load an xlsm file onto an existing excel workbook(.xlsx) with the help of SpreadJS using OfficeJS
I am working on an Web Addin for Excel using officeJS.
My requirement is to allow the user to select a file(.xlsm) from their local drive and load it onto the existing excel workbook as a new sheet.
I ...
- 1,687
0
votes
1
answer
836
views
php artisan vendor:publish --provider="Maatwebsite\Excel\ExcelServiceProvider" BadMethodCallException
run "composer require maatwebsite/excel" in laravel-10 project for excel file but showed "Package phpoffice/phpexcel is abandoned, you should avoid using it. Use phpoffice/...
0
votes
0
answers
117
views
Python Excel Pandas DataFrame Import - Handling nested (and merged) headers
I've spent a few days now working on an issue to import a series of Excel spreadsheets into Pandas DataFrames. I'm relatively experienced in doing this, and can handle a variety of different ...
- 1
0
votes
1
answer
138
views
MS Project get Taskdependencies property via Excel VBA
I am currently creating a macro in Excel VBA to import data from a MS project document.
I included all properties that I want to import in my code but couldn't find the correct for TaskDependencies (i,...
- 1
0
votes
0
answers
447
views
SQL Server OPENROWSET Msg 7302 Cannot create an instance of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)"
I am trying to create a procedure that import an excel sheet in my SQL Server database with SSMS (I am admin).
I have no problem when I do the import manually; my excel file is closed and I can modify ...
- 1
2
votes
2
answers
1k
views
(PhpOffice\\PhpSpreadsheet\\Reader\\Exception(code: 0): Could not find zip member laravel queues job - Laravel
I have application created using Laravel 9.
i have installed 'maatwebsite/excel' library to export and import excel file. it is working good on local and server.
but now i have implemented laravel ...
0
votes
0
answers
425
views
Microsoft query in Excel returning a blank column when SSMS does not
I'm using MS query to return data to Excel from SSMS.
When I run the query in SSMS it runs without error and all fields return with records (see bottom left).
When I run the query in MS Query (to pull ...
- 317
0
votes
1
answer
118
views
Adding Additional Parameter to Excel Import in Rails
I'm using Rails 7 with gem 'roo' 2.9 for doing an excel import. Everything went fine so far.
Now i want to delete part of formerly imported data from my database (postgresql) before i repeat the ...
- 1
0
votes
0
answers
666
views
Laravel Excel Import: "Attempt to read property \"id\" on null"
I am trying to return the id from a relationship based on the excel that is uploaded. When I dd() the variable, the value shows:
enter image description here
Laravel Import
class ContactImport ...
0
votes
1
answer
142
views
foreclosure.com get data from web to excel multiple pages in single sheet
I'm trying to get data from "https://foreclosureindia.com/bank-auctions/visakhapatnam/1" into an excel sheet. Reason being this website doesn't give an option to filter nor sort which is ...
0
votes
0
answers
900
views
Reading formdata binary excel in nodejs
I am sending excel in formdata() property from reactJs as follows
let formData = new FormData(), headers = {};
headers['Content-Type'] = 'multipart/form-data';
headers['Accept'] = 'application/json';
...
- 2,583
0
votes
2
answers
939
views
Showing error "Invalid date value" while importing excel file in Laravel 7
I want to import data from an Excel file. While inserting data, I want to calculate some value depending on the requested Excel file. But the time difference is not returning the correct date format.
...
1
vote
0
answers
235
views
Can I Import Results From Excel Into Test Rail?
We have just started using Test Rail in our business. One of our user testers has extracted their Test Run into Excel and has completed all of their testing within the Excel document (don't ask I don'...
- 11
0
votes
1
answer
244
views
How to create a "bucket" variable in SAS from ranges given in another table
I am trying to create a bucket variable in SAS that will split transactions into various buckets. However, depending on the retailer where the transactions occurred, the buckets have different lengths ...
0
votes
1
answer
3k
views
Stop Laravel Excel Import if a Column has duplicate Values in Excel File
I am using Laravel Excel and what I want is that whenever I upload the excel file and the file has a duplicate row based on some column so how to stop importing data and give the error to the user to ...
- 1,235
0
votes
1
answer
2k
views
How to filter some specific data in Microsoft PowerApps
I am creating a Powerapp which needs to import data from a excel sheet and once those data loaded, I want to edit some of data.
I used Gallery and Gridview and managed to extract data from that excel ...
- 105
1
vote
1
answer
640
views
How to combine many properties into one List<string> property in C#
I am a little bit confused about how to read data from Excel. I am trying to import Excel for updating product list, I create an Excel model; I added all basic properties like name, price, quantity, ...
- 143
0
votes
1
answer
1k
views
How to insert data from excel file with text input field in Laravel
I want to insert data from an excel file into the database. While importing the row from excel file, it will also insert value form input field. Suppose I have an input filed for price. And input ...
0
votes
3
answers
164
views
Convert JSON Objects to JSON object array Without programming Language (exception shell scripting)
I have file containing Multiple JSON Objects and need to covert them to JSON. I have bash and Excel installed, but cannot install any other tool.
{"name": "a","age":"...
0
votes
0
answers
214
views
Excel Import in C# - Missing column error
I have an API that I use to import an Excel spreadsheet into the system and it works correctly although it does not handle missing columns and I am not sure how and at what point I can do that.
I'll ...
- 259
0
votes
2
answers
109
views
R. Problem removing "#NAME?" (from an excel import) in dataframe
I have a .csv import from excel that has formula hangups that I am trying to remove.
A simple version of the data is below.
library(tidyverse)
df <- data.frame(
species = letters[1:5],
param1 = ...
- 99
2
votes
2
answers
6k
views
Date is appearing in number format while upload / import excel sheet in Angular
I am trying to implement uploading the excel sheet using angular but when the sheet is displayed in browser date is changed to number format. For ex. 12-12-2020 is changed to 44177.00011574074. I need ...
- 761
1
vote
2
answers
591
views
Import excel file to database using Laravel
why get undefined offset when importing excel file to the database using laravel.
UserImport.php
public function model(array $row)
{
var_dump($row);
return new User([
'name' =>$...
1
vote
1
answer
183
views
QueryTables problem with scientific notation
I'm trying to import data from a text file, there is no problem with that, the code runs and the data is imported but not correctly. I have text files with this type of numbers: 1.3309884e-13
When I'm ...
- 68
0
votes
1
answer
764
views
Import Excel file into MSSQL via Python, using an SQL Agent job
Task specs:
Import Excel file(s) into MSSQL database(s) using Python, but in a parametrized manner, and using SQL Server Agent job(s).
With the added requirement to set parameter values and/or run the ...
- 105
2
votes
1
answer
2k
views
How to pass user_id for importing excel using Laravel?
I have a problem with excel import using Laravel.
The user wants import excel of suppliers data into database.
The suppliers table got user_id but the user may not have their own user_id. So, when ...
- 61
1
vote
1
answer
1k
views
How can I use Excel to scatterplot more than 255 X-Y pairs from .csv file?
My XY data is converted to a category axis when I attempt to scatterplot more than 303 pairs; bogus data generated IN Excel (such as going to cell B3 and entering B2+1, then dragging that formula down ...
- 11
0
votes
0
answers
54
views
Using rlist on a list of imported Excel sheets causes problems when filtering on certain names
I have dug into rlist and purrr and found them to be quite helpful in working with lists of pre-structured data. I tried to solve the problems arising on my one to improve my coding skills - so thanks ...
- 11
-1
votes
1
answer
145
views
MAATWEBSITE LARAVEL
I want to import data tables(multiple) using excel(single) file. I am not sure how to achieve same with query builder. I am not using model for this.
Excel::import(QUERY BUILDER INSERT QUERY, $request-...
2
votes
2
answers
6k
views
Powershell imported date and time from Excel column are imported with wrong format
I'm importing a Excel document to a powershell script that uses Import-Excel from the ImportExcel module.
The import works great but the column with date gets formatted really weird.
The date and time ...
0
votes
1
answer
147
views
Copying matrix using text import wizard in Excel
I am copying some values from Maple software. It will give the values as
[[1,2,3,4],[2,3,4,5],[3,4,5,6]]
This has to be copied in excel as
[[1 2 3 4]
[2 3 4 5]
[3 4 5 6]]
...
- 121
1
vote
2
answers
5k
views
Excel Connection Manager Failed to Connect via SSIS VS19
New to the SSIS world and I got it working before on Excel Version 2016 & Version 2007-2010 [after ages of troubleshooting] but then it just stopped working [endless testing on various solutions I'...
0
votes
1
answer
34
views
Write back error to datatable bulkcopy C#
I want to make import data from .xlsx to database
the flow as:
xlsx->datatable->database
I copy data from excel to temp table and insert, update to official table later
Everything above work OK but ...
- 3
2
votes
2
answers
8k
views
How to avoid Scientific Notation when importing a csv into Excel?
I'm new in the Stack Overflow community and would very much appreciate any help.
I'm trying to import a csv file from the US Energy Information (Downloadable from the "Download Options" button), ...
- 21
0
votes
1
answer
203
views
Time efficient program for importing an excel sheet and then storing it into DB in servlet
I have written a code to import .xls and store the data into db. It works fine for small amount of data i.e some hundreds of rows of excel. But if the .xls has say 5000 rows, the importing and storing ...
- 362
0
votes
0
answers
30
views
Access VB not importing all Excel colmns
I'm importing an Excel Spreadsheet via VB in Access 2013.
The code brings in all the data from all the tabs except 1. On that tab it only brings in the first column out of the 50 columns. I have ...
- 1
1
vote
2
answers
1k
views
Excel Import of custom mandatory field doesn't work [Hybris 6.7.0]
I'm using Hybris version 6.7.0 and I stuck with the following problem:
When I trying to perform importing products from excel file. It gives me the following error ->
I've checked the excel file and ...
- 371
0
votes
1
answer
1k
views
Maatwebsite Laravel Excel duplicate records are removed
I am using Maatwebsite Excel 2.1. Now the problem is I have an excel sheet that has 5 column names, out of which two column names are the same.
So whenever I do
Excel::load($path)->get()
I am ...
- 185
0
votes
1
answer
165
views
XDMP-INVZIP: Invalid zip file while trying to get an excel file
I am trying to access an excel file from marklogic. When I try to get the manifest I am getting invalid zip file error.
const fileName = "https://www.cisco.com/c/dam/en/us/td/docs/cloud-systems-...
- 115
0
votes
1
answer
4k
views
How to import an Excel document in AzureDevOps Dashboard's widget
For inclusive reporting purpose - I need to get the incident details from Service now and show it in a widget on AzureDevOps Dashboard, along with other development widgets on the same dashboard.
I ...
- 115
0
votes
2
answers
434
views
The given ColumnName 'ACTUAL DATE' does not match up with any column in data source
I am importing my excel file into sql database using sqlBulkCopy but as soon as I start the import this error pops up. I am using MVC5 and entityframework 6. I have checked for the same columns in ...
- 85
0
votes
1
answer
799
views
How to import an Excel File with Nodejs?
I am a nodeJS programmer. I want to the import excel file into my mongoDB database table with validation.
Validation like if any field is blank then that record not inserted into database and after ...
- 247
2
votes
2
answers
4k
views
Maatwebsite 3.1 import multiple model on same method
Hiii! I just trying to using import excel package using maatwebsite . I've succesfully using it horrayyy!! But suddenly I wanna try to import 1 file excel and insert it into two different model. I've ...
- 837
0
votes
1
answer
2k
views
I cannot export woocommerce product description with html to csv
I am trying to export my woocommerce product description to csv with woocommerce functionality and not with plugin.
I then import my csv to excel file and product description is not included in one ...
- 659
1
vote
1
answer
199
views
Format column as Zip Code when exporting from ag-grid
I am exporting to Excel using the Enterprise Ag-Grid built in solutions. Whenever I export a zipcode, any zipcode that begins with 0 loses that in the Excel file. I know that Excel supports a special ...
0
votes
1
answer
467
views
Unformatted Excel data import?
I'm trying to read an Excel file with over 30 tabs of data. The complication is that each tab actually has 2 tables in it. There is a table at the top of the sheet, then a few blank rows, then a ...
- 2,492
0
votes
1
answer
147
views
Excel Import: Param is missing or the value is empty
I don't know why but from one day to the other my excel import doesn't work anymore.
View:
<h1>Import Data</h1>
<br>
<div class="col-md-12">
<center>
<h2>...
1
vote
1
answer
611
views
Updating an Excel Radio Button based on the value of a web form
Currently I have a button on a C# web form that exports all of the user specified values to an Excel file using Aspose. Everything works great until I get to where I need to update a value of a radio ...
2
votes
1
answer
9k
views
Importing data from excel files in D3 js
I am working on D3 js collapsible tree layout, i want to know is there any way we can directly feed the data from excel file rather than using json object file?
- 21