Questions tagged [excel]
Excel is a spreadsheet application from Microsoft with native *.xls and *.xlsx formats.
498
questions
1
vote
1answer
47 views
Using raster file and Excel data for analysis QGIS
I'm using the population density raster from SEDAC (person/square km), I've clipped it to my area of interest (Vietnam) as shown in the picture below:
In addition to this, I have a vector layer of ...
2
votes
3answers
54 views
Importing Excel of multiple sheets into QGIS
I have an excel document of multiple separate sheets.
I can import them one at a time by saving the individual sheets as CSV’s but is there away to bring the entire document into QGIS?
The ...
0
votes
0answers
32 views
Connect coordinates only according to specifications in an Excel list
I have an Excel list with coordinates of shops and their names. I want to connect certain coordinates with the help of a second list.
The second list contains in the first row and column the names of ...
-1
votes
2answers
64 views
Excel XY to (Multi) Polygons
I'm struggling with visualizing a Excel dataset. I have a Excel data table containing a colum with XY coordinates of (multi)polygons, see the screenshot below. Now, I know that it is possible to ...
0
votes
0answers
22 views
Scatterplotting of LST and NDVI
I have created two Raster files (LST and NDVI) I want to determine the slope and intercept of the dry edges and wet edges of the scatter plots of the two datasets to calculate soil moisture, but I don'...
0
votes
0answers
12 views
Symbolizing layer with graduated colors by a field in Excel File
I have a field in Excel file called percentage, I want the governorates colored by the percentage value, so the more value is the more red become darker in the governorate.
So how can I do it in ...
0
votes
0answers
41 views
Can't display XY data in MXD on ArcGIS Desktop- onEnable error
When using Display XY data function on imported excel into MXD I get this error:
and if I click on "ok" then I get this message:
and the MXD get stuck and I must shut down the ArcGIS program. I know ...
0
votes
1answer
51 views
ArcPy: Excel to Table Conversion on multiple Excel files in a folder
I am trying to convert all of xls files (including single sheet) a folder into dbf tables in a gdb.
Here is my code:
import arcpy, os, xlrd
arcpy.env.overwriteOutput = True
arcpy.env.workspace = "C:...
1
vote
2answers
51 views
Mapping RBG color to coordinate possible?
I work with geologists who are trying to figure out how to use Qgis to batch apply colour values to coordinates so that we can visually see differences or patterns.
From the attached photo of soil ...
1
vote
2answers
66 views
Converting Excel files into geodatabase with ArcPy?
I have several Excel files that contain several sheets. I need to convert these files into one table in gdb. I wrote script that convert the whole sheet in separate table. How can I export a range (f....
1
vote
1answer
54 views
Visualizing lines in QGIS
I have installed QGIS and I would like to upload a .xls-file (or Access database) with 2 GPS points (starting point and ending point), a road name and some distances from the starting point, for ...
1
vote
1answer
104 views
GeoJSON file generation based on MS Excel
I am wondering how to CLEARLY generate the JSON file from the data based in Excel file.
I know some ways to do it, although as a result I have got sth like this:
{"type":"FeatureCollection","...
2
votes
1answer
36 views
Add column in QGIS
Is it possible to add a column in the attribute table in QGIS that is a concatenation of two other columns? For example I have a column "Genus" and a column "Species" and I would like to create a ...
1
vote
1answer
26 views
Create Query either using Select by Attributes or Python [closed]
I am working on something for my job, where I have a list of water/sewer service customers. Some customers have one service or the other, while others have both which is stored as two separate entries....
0
votes
1answer
23 views
Export Table to Excel works in ModelBuilder but not in MXD?
I have created model that take user input from a picklist and then outputs the selected data into an Excel File. When I run the model inside of ModelBuilder it outputs an Excel file that is exactly as ...
2
votes
0answers
59 views
QField hyperlinks in Android
I am using QField for some mobile GIS on Android and would like to have a hyperlink in the attribute table that opens a file stored locally. If not in QField directly then in excel would work. None of ...
0
votes
0answers
17 views
Selecting street segments (polylines) based on intersections with others and adding value to its field from Excel table?
I have a shapefile of city streets polylines and an excel sheet with similar data. I need to select a street segment based on the two segments it intersects. Then I add the value from the "ID" field ...
0
votes
1answer
71 views
Imported Excel Spreadsheet Creates Null Values
I've imported an Excel spreadsheet into ArcMap 10.5 and one of the columns entirely populates with NULL values. That column is just "reference numbers" so its just numbers from 1-180 in increasing ...
1
vote
1answer
65 views
Exporting RGB values from raster to file that can be processed in Excel using ArcGIS Desktop?
I have a 3 band raster file with RGB values (the Black Marble night time imagery from NASA). I want to get these values out and into excel so that I can plot them and hopefully see some sort of ...
0
votes
0answers
36 views
MakeTableView of Excel spreadsheet tab gives ERROR 000732?
I have a very simple model built using Modelbuilder that takes a tab of an Excel spreadsheet and converts it using Make Table view. This works fine in ModelBuilder. I then export the model to Python ...
0
votes
0answers
16 views
Populating excel sheet with numerical output of Get Count using ModelBuilder?
Working on ArcGIS desktop 10.7 (very much still learning).
I'm trying to create a model that will count objects from several layers based on the setting of a specific category, then from that ...
0
votes
0answers
45 views
Adding Polygon to shapefile of particular area from Excel?
I have Excel data in which polygon number is given, in correspondence to that there is particular Area given. I have 5000 to these entries.
Now in the shape file, we have to edit every polygon and add ...
2
votes
0answers
38 views
Write Excel From ArcGIS Pro, Async
I am having trouble writing to an excel file from ArcGIS Pro Sdk add-in that I created, I have a basic understanding of multithread, I am using task but the main thread does not wait for the excel to ...
1
vote
1answer
44 views
Add Field disabled on Excel file in ArcMap?
I am a new user to ArcGIS Desktop 10.7. I imported data table from Excel 97-2003 format in the Table of Content. Then with XY recognition the layer was created with the defined coordinate system. The ...
3
votes
1answer
97 views
Converting Lat Long CSV file to meters using ArcGIS Desktop?
I have a large file in a CSV or excel format and want to convert the Lat longs into Northings and Eastings in order to then put them into ArcGIS Desktop and convert those Northings and Eastings into a ...
1
vote
1answer
53 views
Update shapefile with values from Excel cell in QGIS [closed]
I have an Excel table with unique Id values.
1
2
3
4
What I want to achieve is when editing a point shapefile with the same Id field every time a new point is created the Id field is filled by the ...
2
votes
1answer
452 views
Iterating over column from CSV using pandas? [closed]
The problem that I am experiencing is as following:
I have a csv with the following columns: 'time' (with date and time), 'id', 'lat', and 'long'. The data shows movements and id represents a mobile ...
0
votes
0answers
38 views
Retaining co-ordinate values with 6 significant figures when converting shapefile into Excel spreadsheet?
Using ArcGIS-desktop, I converted a shapefile, into an Excel table through the conversion tool Table to Excel, however my co-ordinates previously were specific to the 1x10-6 (i.e. 9.078627) but in the ...
1
vote
0answers
42 views
QGIS 3.6 - Updating layers from changing excel spreadsheet
I am building/editing a table and utilising Excel as the vehicle.
When I change the spreadsheet I need to produce a new csv file and then re-import to generate new layers.
Handling Excel spreadsheet ...
0
votes
0answers
142 views
Extract data table with extended description from Google MyMaps
I would like to extract data table from Google MyMaps and make it usable i.e in Excel.
The issue is straightforward at first glance. I know, that I must download the map in .kml and convert it, as per ...
1
vote
1answer
145 views
Importing long text from Excel using ArcGIS Desktop always shows up as BLOB?
ArcGIS Desktop 10.6.1
I am trying to load long text (>255 characters) into my GIS data. The destination field (let's call it "Field Alpha") is a string field with a length of 2000 characters, in a ...
2
votes
2answers
54 views
Opening different XLS spreadsheets as table with ArcPy?
I am trying to write a Python script that uses a xls file with different spreadsheets as input to build features and domains in a geodatabase.
This is the data in Sheet1:
and this the data in ...
1
vote
2answers
238 views
DBMS error when importing XLSX into ArcGIS PRO
I am working with an XLSX, and consistently receiving either a "underlying DBMS error", or associated with the file.
I have worked through all the suggestions and limitations from ESRI to the best ...
1
vote
2answers
61 views
Decimals are in wrong place in latitude and longitude in Excel
Somebody gave me an Excel table and the latitude and longitude had the wrong place for decimals. Is there a workaround to fix the problem? I am pretty much stuck trying to figure it out. Here is the ...
0
votes
1answer
56 views
Viewing File Geodatabase table in Excel with link not export?
I have a situation where I need to create a regular report from information in a file GDB (10.6) attribute table. I would like to avoid exporting the info to CSV each time I run the report, then ...
1
vote
1answer
35 views
Copying first record from series of feature classes into separate file using ArcPy? [closed]
I have 1000 files from which I need to copy the first record and insert into a new feature class. Additionally, is there a way to do this without copying the Field headers as well?
The end result ...
0
votes
1answer
16 views
Blank Excel fields creating problem in Creating TableView using ArcPy? [closed]
I was about to take input from an excel and using conversion tool in arcpy I have to convert the excel to table in a gdb. But when I used this Excel to table tool, I found that there are columns named ...
0
votes
0answers
20 views
Pasting Column into QGIS from Excel? [duplicate]
This should be incredibly simple, but I cannot figure it out.
Is there any way to paste a column from excel into an existing column in a QGIS attribute table?
1
vote
0answers
31 views
Interpolating sea level data using ArcGIS Desktop?
I have monthly sea level data obtained from PSMSL in the form of excel sheet for the region Chennai.
I want to interpolate the data in ArcGIS Desktop. The shapefile of the region has Polygons and I ...
0
votes
0answers
206 views
Editing and saving CSV file to use in plugin for QGIS?
For using in a plugin (PS Time Series Viewer), I want to edit a CSV file in the way plugin wants. Somehow I think there's a problem with the CSV file. I would like to tell you all my steps because I ...
2
votes
2answers
104 views
Automatically (re)classify data from layer using QGIS?
Is it possible to automatically (re)classify the data of a layer? (properties-symbology-delete all-classify) Because now I have to do this manually each time my data source changes.
3
votes
0answers
259 views
Automatically update and reclassify project layer from Excel data
I have a project in Qgis that gets its data from a locally stored excel file (linked). Is there a way to automatically update the linked data? What is happening now is that when I change some rows in ...
0
votes
0answers
43 views
Feature layer (AGOL) export to Excel failure?
When I try to export data from an AGOL feature layer into an xlsx i receive the following error.
"Excel cannot open the file, file format or extension is not valid"
When selecting to export you don'...
0
votes
0answers
45 views
Multiplying individual raster layers by corresponding values in Excel file?
I have two groups of items I want to multiply, using the Times tool.
I have a geodatabase full of density raster layers.
I also have an excel sheet. This excel sheet has a column listing the names ...
0
votes
1answer
63 views
Using ModelBuilder to Create Python Script for xls to csv Conversion?
I am currently trying to create a python script within ModelBuilder to convert an xls file to csv.
I created one already using the "Table to CSV" tool which was successful. However, I tried to add ...
4
votes
1answer
388 views
ArcGIS Desktop not recognizing updates to xlsx?
I load an xlsx file into ArcGIS Dektop 10.6.1, and realize I didn't have headers in my xlsx so I need to go back and add those. I close everything since ArcGIS locks xlsx files down and won't allow ...
1
vote
1answer
162 views
Making relationship class between feature class and Excel table with ArcGIS Desktop?
I have a feature class of parcels and an Excel table of other information related to those parcels. Goal: would like edits from an Excel table to get passed onto feature class. Problem: for a true ...
0
votes
0answers
30 views
Importing Excel file into ArcGIS
I am importing Excel sheets into ArcGIS for map-making purposes. I have one column that is not recognized. I cannot figure out what is wrong with it, I have deleted it and remade it, checked the ...
1
vote
0answers
74 views
Empty error when running Table to Excel tool [closed]
The Table to Excel tool in the Conversion toolbox does not work for some reason. When I open it, it shows a red cross in the top left corner. When I try to run it an error pops up that says nothing. I'...
1
vote
0answers
60 views
QGIS automation field from Excel
I present the following situation.
1 - Draw polygon shape in QGIS 3.4 / geopackage, only with two columns ID and NUM_SETOR, using the google maps image as reference.
2 - Excel table where I combine ...
