Skip to main content
734 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
1 vote
0 answers
633 views

I try to upload Excelsheet in to an existing PowerApp table. The Excelfile is localy stored on the laptop. I try to use the import -> import data from excel functionality in PowerApp. I need to do ...
Erik hoeven's user avatar
  • 1,648
2 votes
1 answer
192 views

I have 6 files (5 xlsx, 1 csv) in Google Drive folder which I want to import into 6 different tabs of Google Sheet. Tanaike proposed a solution here that works well if the file size is not big. ...
EagleEye's user avatar
  • 522
0 votes
0 answers
78 views

I am trying to create a 3D scatter plot. I don't know the etiquette behind changing code as it's edited... so have just replaced with latest version. I'm now getting a 3D plot - not sure how to change ...
Liz L's user avatar
  • 43
1 vote
2 answers
866 views

I am using Jupyter notebook 7.0.8 DuckDB version v0.10.2 import duckdb as d con = duckdb.connect("mydb.db") con.sql('INSTALL spatial') con.sql('LOAD spatial') con.sql("""...
ArtBajji's user avatar
  • 960
0 votes
1 answer
569 views

I have an excel file which I have imported into R using read_excel. The excel file contains about 8000+ records with 58 columns. There are many cells with NA values. Across the different variables, ...
user1845518's user avatar
  • 45
1 vote
0 answers
236 views

When deploying an astro website to vercel, it keeps showing me this error: Error: Config file was not found at "/vercel/path0/.vercel/output/config.json" at tb (/var/task/sandbox.js:395:1589)...
Pcoi94 Pro's user avatar
  • 11
0 votes
1 answer
202 views

Can you please tell me if there is a way to export data from CSV file to postgress database according to conditions? By condition I mean a situation where there are two tables in a postgres database. ...
Andrei's user avatar
  • 353
0 votes
1 answer
489 views

I am looking for a solution to copy specific cells from an Excel spreadsheet containing over 1000 names. Each name is associated with a number in an adjacent cell. I need to copy these numbers and ...
Mhmd Sabry's user avatar
  • 1
0 votes
0 answers
289 views

I'm banging my head here on this one. I have TXT files that need to be imported Acrobat forms. My data imports flawlessly with the manual method ("Forms->Manage Form Data->Import Data")...
JavaNovice's user avatar
  • 1
0 votes
0 answers
56 views

I'm trying to import data from Excel to my SQL Server database but when I open it, I get this error: The 'Microsoft.ACE.OLEDB.15.0' provider is not registered on the local machine. (System.Data) I ...
mujahed issa's user avatar
  • 1
0 votes
1 answer
425 views

I want to extract an image out of an excel sheet. Note the image is not inside any of the cells but rather floats on top of our cells. XLSX library only extracts cell information so that is not an ...
Mohsin's user avatar
  • 86
1 vote
1 answer
1k views

Is it possible to read only the headers from an Excel file using PowerShell and Import-Excel module? I've an Excel file with multiple sheets. One of them only contains headers and now data rows. After ...
John Doe's user avatar
  • 10.3k
0 votes
1 answer
531 views

How can I update an existing Excel file with multiple sheets using PowerShell. I'm using the below code for an Excel file with a single sheet, but need to do something similar to an Excel file with ...
John Doe's user avatar
  • 10.3k
0 votes
1 answer
123 views

So I was making a Kivy program in which it imports data from an Excel file of which I give the path as an input. I am currently using the read_excel function of pandas to read the file. it works ...
Divyam Sud's user avatar
  • 11
0 votes
0 answers
38 views

Through the below code, I want to import an excel file into my grid and append it to the grid. For example, if I have 2 rows in the excel sheet and 4 in the grid, then after importing, the grid should ...
Muskan's user avatar
  • 3
0 votes
2 answers
668 views

I have a kendo grid and I want to import and append an excel file to my kendo grid. For example, if I have 3 rows in my kendo grid, then after importing the excel file containing 2 rows, the grid ...
Muskan's user avatar
  • 3
0 votes
1 answer
260 views

Could you please help - for an existing report, I simply changed the data source (Excel file). File is identical format/columns etc. I already resolved the import issues (like PBI Changed Data Type, ...
aphlafemale's user avatar
  • 1
0 votes
0 answers
56 views

I am being supplied a CSV/XLSX file exported from a system for which I have no control. The exported CSV file can contain multiple (up to 6) rows for each patient with their different diagnosed ...
LloydC's user avatar
  • 7
0 votes
1 answer
343 views

I have a time column in Excel that contains values of Time Type in the following format: 03:11:00 When I add the Excel File as a Source in ADF, it automatically converts it to DateTime and when I ...
Olgaraa's user avatar
  • 123
0 votes
1 answer
887 views

I am trying to get data from xlsx file using Proc Import procedure and it was successful but when i look into the data. The variable doesn't have the complete text value and length of that variable is ...
shaik khadar's user avatar
  • 7
-1 votes
4 answers
10k views

My laptop is windows and my system type is 64-bit. I have the newest version of SSMS (19.1) downloaded and when I try to import the data into my database I get the error The 'Microsoft.ACE.0LEDB.12.0'...
EricE's user avatar
  • 9
0 votes
0 answers
136 views

So I have this dataset. Problem is, the data came in a zip file, which, once unzipped, contains 800+ folders. Each one of those folders contains half a dozen or so files, only one of which contains ...
user22085188's user avatar
  • 1
0 votes
1 answer
142 views

** Update i made it work i needed to put the entire foreach inside a variable and it works Powershell Foreach overwrites the output in excel I have a script need help fixing it , the excel output is ...
Mr.RamGoat's user avatar
  • 1
0 votes
1 answer
35 views

When importing data from the excel attachments on connect, the column headings appear as column data and it makes it difficult to work with the data. This is the what it comes out as. WebHits and ...
Lindo George 's user avatar
  • 1
0 votes
1 answer
677 views

I use SQL Server 2022 Express, and SQL Server Management Studio. I'm trying to import an Excel file into a database I created. I click on its name with the right button => task => import data. ...
יעקב גולדמן's user avatar
  • 1
0 votes
1 answer
256 views

I'm having some trouble finding the ideal way to convert my Excel spreadsheet to C# models. I've got some MVP code that's using the EPPlus library, but it's really simple in that it only opens the ...
beepboop's user avatar
  • 65
0 votes
1 answer
84 views

I am using RStudio to practice data cleaning and visualization in R. I downloaded and imported several excel files into R Studio. But now, I want to combine the 5 separate files into one long file ...
Kristopher's user avatar
  • 1
0 votes
0 answers
45 views

I'm trying to get data from Excel cells. I'm using: using Microsoft.Office.Interop.Excel; using Application = Microsoft.Office.Interop.Excel.Application; 'selectedRange' is null. I have to use .Net 4....
Mateusz Koniuszaniec's user avatar
  • 1
1 vote
2 answers
191 views

I was trying to import excel to sas grid and add the last modified timestamp for the file into the table. Referred to the sas support I was able to retrieve the last modified time. But I am having ...
yang chaoyi's user avatar
  • 11
0 votes
1 answer
297 views

am new to stata, this is my first time to use it :( i have the data set for firms operate in kuwait market for 10 years, from 2013 to 2022, each year in a different excel files. so i have total 10 ...
nhararah's user avatar
  • 1
0 votes
1 answer
541 views

I have several rows of data on KPIs (monthly basis) and want to compare the latest month (e.g. March 2023) with a specific target value that is the same for each month. Ideally, I want to use the KPI ...
Nils_Denter's user avatar
  • 498
0 votes
1 answer
83 views

I wrote a script that imports data from an excel file to the database, but the runtime is extremely slow. It worked fine with the sample excel that had 20 row, but I will need to import from excels ...
Benjji's user avatar
  • 21
0 votes
0 answers
59 views

I am new here. I'm trying to create different folders with different names from an Excel file(table with row and columns) in a specific path. Below my coding. import openpyxl import os w = openpyxl....
Robertus83's user avatar
  • 1
0 votes
1 answer
1k views

I have a bash script which reads from .csv to a table in PostgreSQL 11.16.The .csv file is generated by mysql select statement. PGPASSWORD="${DATABASE_PASSWORD}" psql -h "${...
dpsg's user avatar
  • 1
0 votes
0 answers
46 views

I am trying to separate a column.. I have columns (date, lmp, node). The code recognizes date but does not recognize lmp and node. names(Pjm) # [1] "date" "lmp" "node" ...
Omushien's user avatar
  • 1
0 votes
1 answer
534 views

I have two models: Project and Activity. When registering a project, one or more associated activities can be added. How can I import projects from xlsx, which include at least one activity?. I'm ...
Willuq's user avatar
  • 1
0 votes
0 answers
141 views

I use list apply to simultaneously import multiple (hundreds) of excel files ( using read_excel funtion to import specific cell range) into R followed by rbind.fill to build a single r dataframe and ...
Daniel's user avatar
  • 1
0 votes
0 answers
30 views

I have some registers like 1D-2, 1E-2, 1F-3, and so on in a system. When exporting a .csv from the system, and reading the file in excel the rows with "E" in the name are automacally ...
Vinícius Félix's user avatar
  • 8,896
0 votes
2 answers
220 views

I'm making a data import feature from excel using maatwebsite. I successfully imported the data into the database, but the year data that should have been 01/01/2022 and 31/12/2022 instead became 01/...
akhiratunnisa's user avatar
  • 11
1 vote
1 answer
266 views

I am trying to import via a VBA button a ton of Excel data (around 30k + daily) into an existing table in SQL server. My question is how can I do this as simple as possible, code speaking? The headers ...
AlexandraStk's user avatar
  • 35
0 votes
1 answer
780 views

I have table in SAS like below: TABLE 1 COL3 | COL2 | ... | COLn ------|------|------|---- 111 | ABC | ... | 12 222 | AAA | ... | 10.5 333 | app | ... | 5 ... | ... | ... | ... And ...
dingaro's user avatar
  • 2,350
0 votes
0 answers
97 views

I imported a file ising QA= pd.read_excel("/.../.../QA.xlsx",sheet_name='data',engine='openpyxl') Yet I am getting an output in python with unnamed columns (Unnamed 0, Unnamed 1,...) and ...
Spearitch502's user avatar
  • 25
0 votes
1 answer
2k views

I want to automatically import an xls file that i save to a specified local folder on a laptop weekly to a Google Sheets. I want to replace the data in a sheet each time the import is done. The file ...
Martin Robertson's user avatar
  • 1
0 votes
0 answers
84 views

I am a spark scala newbie and I am trying to import a csv file from git repo into scala 3. I have tried using the panda example but, I am getting a few errors. Errors: Cannot resolve symbol url_github ...
Kacie's user avatar
  • 3
1 vote
1 answer
128 views

I want to import a file called ExcelToImport.xlsx file allways into a same file called UpdatedGSheet.gsheet file I have created the UpdatedGSheet.gsheet file and taken its id from its url I have ...
OmarPoch's user avatar
  • 11
0 votes
0 answers
75 views

I am trying to import this dataset which is in csv (comma delimited) and i am not able to do it in r, i believe because the first column doesn't have quotes, month has quotes in every rows and so on.....
mafalda's user avatar
  • 31
0 votes
1 answer
192 views

I have a problem where I'm importing a CSV file using the SQL import wizard but the values being imported get changed after this process completes which I'm not sure why this is happening. I have ...
Brakkie101's user avatar
  • 169
0 votes
1 answer
4k views

I am trying to import Excel file [using Laravel Excel library] into two different models that has relationship between them. I tried the below solution by returning two models import, and the second ...
CairoCoder's user avatar
  • 3,237
0 votes
0 answers
596 views

I'm having a problem (without errors) when I try to import data, skipping the email if already present, from an external file; the data is not imported. This is my code. ImportClass namespace App\...
Sarah's user avatar
  • 285
0 votes
0 answers
321 views

I am trying to import a table from this webpage: http://www.eybl.lv/new/ce_u17_game.php?game_id=5746141&season_id=125274#mbt:103-400$t&0=1 When I try to import the table, power query does not ...
clay's user avatar
  • 19

1
2 3 4 5
…
15