Skip to main content

Questions tagged [excel]

Excel is a spreadsheet application from Microsoft with native *.xls and *.xlsx formats.

Filter by
Sorted by
Tagged with
0 votes
0 answers
30 views

Cannot open xls file using Python in ArcGIS Pro 3.1.2

I have the following code: import arcpy arcpy.env.overwriteOutput = True coordinates = r"C:\Tiedostot\folder1\coordinates.xls\Sheet1$" print(arcpy.Exists(coordinates)) cursor = arcpy.da....
cloudberry's user avatar
0 votes
0 answers
15 views

Absence of Excel number script coordinates

I have written the following script code and it has given me the monthly data of the annual growth of wheat from 2000 to 2023 in the form of graphs and Excel. Then I have added the slope of the ...
Jabar Razie's user avatar
1 vote
1 answer
38 views

Exporting MXD file from ArcMap to PDF using ArcPy not retaining embedded Excel tables when converted to PDF

How can I alter my script so that the Excel tables embedded in my MXD are displayed when converting to PDF? import arcpy import os mxd_path = r"D:\CROQUIS_PYTHON\MXD" pdf_path = r"D:\...
Yonander tomaylla yupanqui's user avatar
0 votes
0 answers
56 views

Openpyxl module not working QGIS 3.34.7 when data is added. Why?

i tried write excel file using openpyxl module. CODE: log = [['ID', 'LAYER NAME', 'ADA', 'ERROR DESC', 'REMARKS'], ['', 'cable_assignment', '', 'Duplicates Values In CableAssignmet'...
Velugoti Venkateswarlu's user avatar
0 votes
0 answers
35 views

Export attribute table to Excel without vertex-points

When exporting an attribute table the amount of vertex points (correct?) sometimes makes multiple rows in Excel. Is there a simple way to stop that?
Åke Eriksson's user avatar
3 votes
2 answers
134 views

Drawing routes (on road shapefile) between X,Y coordinates in QGIS

I've got a column with 300 of start points and 300 of end points (X,Y coordinates for each point). I now want each row in the column to connect with each other (e.g. X,Y Coordinate for Start Point, ...
A M's user avatar
  • 31
1 vote
0 answers
58 views

Adding photo in QGIS Attribute table and exporting in Excel

I want to export an attribute table in Excel with photos visible in table but in Excel in QGIS is visible like path-link, but I want to be a photo. Any idea?
Tania D.'s user avatar
4 votes
2 answers
113 views

Select features by joining table in QGIS

I have .shp layer with field "FIELD_1" in the attribute table (5000 records). I have also Excel file with field "FIELD_2" in the attribute table (1600 records). I want to select in ...
com's user avatar
  • 3,684
0 votes
0 answers
38 views

Joining Excel to attribute table

Im working with ArcGIS Desktop (ArcMap), trying to create a geodatabase. So I have a bunch of coordinate points to create polygons and an excel full of attribute data about those polygons. What ...
Erin Tesden's user avatar
0 votes
0 answers
33 views

Calculating intersection of a line segment with a circle on Earth's surface from latitude and longitude coordinates

I'm working on a problem where I need to determine if a line segment between two geographical points on the Earth's surface, intersects with a circle on the Earth's surface, defined by a central point ...
AM-A's user avatar
  • 1
0 votes
0 answers
32 views

Setting up a dynamic spreadsheet to join with feature layer in ArcMap

I am building a map of about 500 storage units that are being acquired and relocated, each unit is represented as a polygon. Each polygon is coded by Unit Number and will go through about 5 different ...
kkaszas's user avatar
  • 290
1 vote
0 answers
41 views

Creating Streams from endpoints and NHD Stream Layer using ArcGIS Pro with Spatial Analyst

I have a dataset for instream flow water rights that delineates the length of stream based on upstream and downstream endpoints and the miles of stream. I'm trying to create a GIS layer for this ...
Bri's user avatar
  • 11
2 votes
1 answer
128 views

Sorting coordinates as per polygon in QGIS

I have a list of our sales lead locations in Excel with their coordinates. What I wish to do is that I need to sort those coordinates as per the condition if they lie within a certain polygon or not. ...
VVstack43's user avatar
1 vote
1 answer
97 views

How to write AGOL data into an Excel sheet using FME

I am using the AGOL feature service reader to read in the data and then writing to an Excel file. In the Excel writer parameters I have set the template file and sheet and set the mode to "update&...
Will97's user avatar
  • 19
0 votes
0 answers
430 views

How to use an Excel file (.xlsx) in QGIS

So I have an Excel file where I want to use built in Excel features such as restrict data type in columns etc. but I want to use QGIS to display the data. I know that I can change it to a CSV file ...
axel_ande's user avatar
  • 2,044
4 votes
1 answer
97 views

Importing several CSV files without losing leading zeros from OS NGR into QGIS

I have ten CSVs that I need to import, in order to turn them into geopackages/shapefiles so I can edit the attribute tables etc etc. The ten files have a combined total of about 15000 entries. Each ...
Matt Mansfield's user avatar
0 votes
0 answers
30 views

Inaccurate attribute values using joins attribute in QGIS

I have a shapefile data that represent the location (polygons) and a tabular data represent its detail information. I want to merge the tabular data to the shapefile. I use QGIS 3.22.12 Here are the ...
Azzam Zainurrafi's user avatar
0 votes
1 answer
179 views

Converting Excel integer date format to date using ArcGIS

Similar question as this post: Converting Excel integer date format to datetime using QGIS, but for ArcGIS. I have a field with integer values like 45118 which came from a column in Excel containing ...
Matt Leonard's user avatar
0 votes
1 answer
412 views

Import JSON file as table in Excel and visualize polygon geometry using ArcGIS plugin for Excel

I have a quest where I have to visualize the polygons in my local disk in Excel using ArcGIS plugin. Based on what I understand, I can only import it as a JSON file from the get data panel, but the ...
Ashmitha Nihar's user avatar
0 votes
1 answer
53 views

Combine several attribute tables into a single Excel

Is it possible in QGIS to combine several attribute tables into a single Excel? Unfortunately, I cannot find a suitable function/command. Copying and pasting all attribute tables individually is too ...
ToSa's user avatar
  • 1
0 votes
1 answer
79 views

Create an ArcPy script to open a pop up window with some exporting functionality just after running trace tool from utility networks runs successfully [closed]

I am new to ArcPy. Suppose I ran the Trace Tool from utility network toolset using ArcGIS Pro successfully, and I need to immediately a pop up window comes up with the export functionality to export ...
Kumar Prince's user avatar
-1 votes
1 answer
69 views

Generate Excel files from an attribute table using a certain field

I have got a table with many fields, where one of them is the main one, as they are sectors of a region in Spain (Comunidad Autónoma, in Spanish). I know I can export that table to Excel from ArcGIS ...
Francisco José Luque Fernández's user avatar
0 votes
1 answer
63 views

Transcribing KML without metadata

I use Google Earth KMZs for fiber optic network designs and I need to transfer info over to Excel for ordering purposes. I'm using the Placemark and Path features in GE to correspond to items we order,...
Guest's user avatar
  • 1
2 votes
0 answers
529 views

Exporting large attribute table from QGIS to Excel

I am working on a project with an attribute table of approx. 5,564,098 rows. I've tried exporting it to Excel using the "save as" CSV or XLS but the data keeps getting cut off. I would ...
Peyton's user avatar
  • 21
1 vote
0 answers
49 views

QGIS - Working in the attribut formular with Widgets

I want to transform my attribut formular for biotopes to add automatically their value depending on two former columns. I have an excel table like this: Code rating1 rating 2 value A dry species-...
Geographika's user avatar
0 votes
0 answers
328 views

Utilize ArcGIS Python script tool parameters to convert Excel file into a projected featureclass

I am creating a Python script tool in ArcMap to help automate some GIS tasks. The script takes an Excel file( that has Lat/Long fields with values) as the first input parameter. The second parameter ...
Ryan Mags's user avatar
1 vote
1 answer
444 views

FME: Import an Excel table as user parameter list

I have a list of possible errors in an Excel table and I am importing it as a Reader. I run more than 100 controls on my data and I generate a txt file with the data that don't pass the tests and what ...
Theodora's user avatar
  • 171
3 votes
1 answer
614 views

Live synchronisation Excel to QGIS

I am looking for a solution to synchronize a vector layer to an Excel-file in both directions. So if I add a geometry within the vector layer, it shall also be written in the Excel-file and if I ...
lesto's user avatar
  • 327
3 votes
2 answers
167 views

Include the processing tool "exporttospreadsheet" into my plugin

I made a Plugin containing features for a specific workflow. As the last function I wanted to add the qgis processing tool "ExportToSpreadsheet" (Layertool) into my plugin. It's a native ...
geofreak's user avatar
  • 121
2 votes
1 answer
215 views

Problem with data input. CSV with polygon coordinates to polygons in QGIS

I have a .CSV file with information about polygons (which are squares), represented by the coordinates of the four points that shape a square (4 pairs of long/lat coordinates) All are in one column, ...
christian4vk's user avatar
3 votes
2 answers
10k views

ModuleNotFoundError: No module named 'xlsxwriter'

I created a plugin that export some data from the layer to some excell. The problem that I'm facing, as the title says, is that Module xlsxwriter is not found. To save some answers, yes I installed ...
Diogo Barros's user avatar
0 votes
1 answer
240 views

Exporting FileGeodatabase Subtypes to Excel

I'm working with a large file-geodatabase(100 layers) and need to create an excel spreadsheet listing all the subtypes with values and labels extracted. Is there a way to do with this task with out of ...
GISMapper's user avatar
  • 387
0 votes
0 answers
156 views

QGIS save DAT,MAP,ID,TAB, Excel file in an existing geodatabase

I am using QGIS 3.10.3. I need to add some files (DAT,TAB,MAP,ID and Excel) into an existing geodatabase. As I am new to QGIS, how can I add those files into a geodatabase.
GIS Noh's user avatar
  • 321
2 votes
1 answer
280 views

Exporting selected attributes to Excel from specific layer using PyQGIS

I have created some code to select a specific layer in the Layers Panel. Now I want to export the selected features to an Excel document. Is there a way to do this? Code so far: #Select layer to ...
matthew whitehead's user avatar
0 votes
1 answer
128 views

Using Excel table to create new attribute values

I have an Excel table with energy values per building age range and per building type. I want to read add a new feature in my point layer with corresponding energy values. How can I read the Excel ...
Sander Van Beuningen's user avatar
2 votes
2 answers
104 views

QGIS 3.22.11: How can I attach different species to one polygon in a polygon layer

I have a polygon-layer with several polygons, and I have an excel-table with many detected species in some of these polygons. I want to attach all the species that belong to polygon 1 to polygon 1, ...
Bertram's user avatar
  • 483
1 vote
1 answer
248 views

Adding multiple points using Excel data in QGIS

How can I add more that one point to a specific location (defined by lat and long coordinates) using an Excel file? My table looks like this: City name Latitude Latitude A1 A2 A3 New York 40.785591 -...
Catalin Alexa's user avatar
0 votes
1 answer
165 views

Importing labels at specific X,Y points using ArcGIS Pro

I am trying to load an excel file into ArcGIS Pro that has 3 columns x,y,label like this X Y Code 396051.35 -616690.04 Ag01 606336.43 -616823.57 Ag02 I need to output a shapefile ...
Ayman Zekry's user avatar
1 vote
2 answers
548 views

Extract field details for all layers in a geodatabase

I have inherited a file geodatabase containing a number of feature classes (points, lines and polygons), where many fields are common. For example all feature classes contain the following fields, and ...
boberdorf's user avatar
  • 1,357
3 votes
4 answers
675 views

Importing from Excel/CSV format to QGIS

I created a grid and used it's squares and it has 4 values in attribute table (each square has left, top, bottom, and right values). Every square is a different object. I try to export file from ...
waseem hasan's user avatar
-1 votes
1 answer
354 views

QGIS does not read all .csv Excel columns [closed]

When I import my data from Excel into QGIS, the GPS points are found. However, not all columns that are present in the Excel are shown in the Attribute Table. At times, they have completely ...
user207306's user avatar
0 votes
2 answers
175 views

QGIS doesn't show datapoints of .csv file

I am not yet familiar with QGIS and I am trying to add an Excel file with GPS points and data (add layer > add delimited text layer). The Excel shows up as a layer, but the points do not show on ...
user207306's user avatar
0 votes
1 answer
825 views

Converting .xls to .shp

I'm very much a GIS novice but have been maintained an interactive tool on arcGIS for several years and am only now experiencing a problem with it. We are collect and update data on an Excel ...
Lily's user avatar
  • 1
0 votes
0 answers
43 views

Joining an Excel tabel to single polygons of a feature layer

I am trying to associate the contents of an external Excel spreadsheet with individual polygons of a feature class. I have a layer that has hundreds of polygons. I also have an Excel spreadsheet that ...
Ni.ccoo's user avatar
0 votes
1 answer
51 views

Can ArcMap use Excel equations in the attribute tables?

I am very new to ArcMap and am learning as I go. I am trying to have one Column be the current date. In Excel I used "=Today()" and that clearly works fine but it does not seem to be ...
Spencer's user avatar
3 votes
1 answer
2k views

Using QGIS field calculator to create an 'fid' column according to a value from another column

I have a shapefile with 1,800 rows. I need to edit this file as follow: Row_name is from 1 to 45 Col is from 1 to 39 fid should be from 1 to 1800 in order (This is the new field I need to create). I ...
Jose Luis Landivar S's user avatar
4 votes
2 answers
634 views

Export from layer to Excel in QGIS with alias fields

How can I export a layer to Excel format in QGIS environment and have alias of the fields in the header of the Excel file instead of the original field names?
RandyO's user avatar
  • 131
3 votes
1 answer
577 views

QGIS print layout - export legend items to Excel

I have the well-built legend in the QGIS print composer, as my project includes more than 20 layers. Because the legend in front layout doesn't match our legend patterns produced in Excel I am ...
Geographos's user avatar
  • 4,029
0 votes
0 answers
108 views

Extracting average value at point using ArcGIS Pro

I have a dataset of over 500 points that represent the location of a number of site boundaries and a Tif file displaying the wind speed data over the study area. Is it possible using ArcGIS Pro to ...
Robbie-G95's user avatar
2 votes
2 answers
118 views

Using QGIS expressions to edit columns automatically according to a repeating pattern, similar to Excel dropdown/autofill

I have a geoJSON file with 4,500 rows. I need to edit this file as follow: if plot_num starts with 2 -> rep = 2 first 11 rows of line = 1 second 11 rows of line = 2 I have been updating the ...
Jose Luis Landivar S's user avatar

1
2 3 4 5
13