Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [excel]

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

0
votes
0answers
6 views

Warning Could not add the specified data object to the map

When I try to add data (Excel spreadsheet) from the Catalog I get the warning message noted above. Previously I have been able to add data from Excel files.
0
votes
0answers
20 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
26 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'...
0
votes
0answers
12 views

How to collate data and access collated list - Survey 123

https://communityhub.esriuk.com/geoxchange/2017/11/17/how-to-work-with-other-in-survey123 The above link is the resource I used to collate my data. I did nearly exactly what the webpage above ...
1
vote
0answers
37 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 ...
2
votes
0answers
25 views

Copying Table of Contents from QGIS into Excel?

Is there a way to copy and paste the contents of the Table of Contents in QGIS into an Excel spreadsheet? For example, I have many layers (groups of vector shapefiles which are underneath various '...
0
votes
0answers
39 views

Creating geodatabase table from pandas data frame?

I have a .xlsm file which I use to update an existing point feature class, with the information from a certain sheet. The data from the sheet has to be projected in GIS using Route events, and later, ...
1
vote
0answers
23 views

QGIS hyperlink to specific row/column excel

Is there a way to set a hyperlink to a specific sheet/row/column in an excel document? I am able to link to an excel file on the server and open it from QGIS, but would like to open the document to a ...
0
votes
1answer
25 views

Formulation of CRS (EPSG2438 to EPSG4326) conversion in Excel

I have about 14000 points with coordinates EPSG2438 and want to convert the coordinates into WGS84 (EPSG4326). I want to know that is there a way to make Excel formula to convert these coordinates. In ...
0
votes
1answer
22 views

Zeros disapearing in front of numbers when exporting from attribute table

I have a large set of points in ArcMap desktop. In the attribute table I have a column called ID, where each point have an individual number. Some of these numbers starts with a double-zero, which is ...
-1
votes
0answers
14 views

Insert Object -excel spreadsheet - missing columns

I am trying to insert my excel spreadsheet by using insert object - from file- and link it. It all seems to work fine, but the last columns of my tables are missing. How do I get around this? ...
1
vote
0answers
25 views

Interpolate and export the following points

I have two crossections of the same position. I am looking for a way to interpolate the blue points from the attached image. I need the xyz values of the interpolated points, how can I do this? I ...
5
votes
4answers
125 views

Converting Excel into shapefile (keeping encoding and data type)

I am trying to create a "perfect" shapefile from the Excel data. "Perfect" means that it should match several factors: proper encoding and original data type. Excel file basically contains ...
0
votes
0answers
33 views

Field Mapping From Excel Sheet to GDB Table

I am trying to map Excel fields with GDB fields. Here is what I tried def creatingFieldMapping(self, excelPath, mappingList, fgdbFolderPath): segColList = [] workbook = xlrd.open_workbook(...
1
vote
0answers
83 views

Filter on joined tables in QGIS

QGIS 3.2.3: I have a shapefile and an Excel table which is joined to the shapefile based on matching IDs. I would like to filter the shapefile while using a joined field from the Excel table. When I ...
1
vote
1answer
23 views

Using ArcPy with Windows Task Scheduler script cannot read Excel file?

I have an arcpy Python script that downloads an Excel spreadsheet and then copies one of the sheets from the document to a table in a geodatabase. I need this script to run automatically every night, ...
3
votes
2answers
66 views

FME geometry conversion from string?

I have an xlsx file that has incorrect X, Y location. Essentially the false northing is out 5000000 and there's no decimal point. As you can see in the image below the current file format is on the ...
1
vote
1answer
58 views

Excel to GDB field mapping and importing Excel data in geodatabase?

I've got one Excel file which consists of data. I need to export that data to a gdb table. There are challenges. The gdb schema does not match with the Excel schema (I mean column names are different ...
0
votes
3answers
50 views

Filtering attributes in a shapefile using a common ID from an Excel file

I am using QGIS 2.18.11 and I have a shape layer with lines and polylines I need to review; but not all of them, only certain ones. The ones I need to review are marked in a specific field (rev = 0 or ...
3
votes
1answer
40 views

Separating list with coordinates in two different coordinate systems using ArcMap?

I have an excel list with approximately 10.000 poles which I want to export to a Point layer to view in ArcMap. However, the coordinates are a mix between SWEREF99 and RT90 and I am not sure how to ...
0
votes
0answers
54 views

Exporting into Excel file from PyQGIS?

The following code allows me to save a text file with .xls extension in Python. When I open it, I receive the following warning: The file you are trying to open, is in a different format than ...
1
vote
1answer
27 views

Assigning value to building type using ArcMap? [duplicate]

I have a building dataset that shows areas of different building types ie. educational, medical, and residential. How do I assign each type of building a numerical value so if I have 7 buildings ...
1
vote
0answers
40 views

Exporting several maps with excel sheet using Arcpy

I try to export 20 maps with this python code in ArcGIS 10.3.1 for Desktop. Each map has excel sheet (not attribute table) in the layout view. The excel sheet file located in G:\Users\test\Downloads ...
0
votes
1answer
38 views

Error message while trying to load spreadsheet: Failed to connect to database. Class not registered

I am trying to load an Excel spreadsheet into ArcMap 10.6 in Windows 10. But it will not load and this is the error message:
0
votes
0answers
38 views

Using ArcMap add x y data, points are in wrong location [duplicate]

According to ArcGIS esri when I add a CSV with the "add XY" tool, * "The tool automatically adopts the data frame’s coordinate system"*. Since I'm importing a csv with no defined coordinate system, I ...
0
votes
1answer
29 views

Table join to KML file

I want to add a classification to photos which are in an excel spreadsheet within a KML file. Need a way to combine/join fields that are in an Excel spreadsheet to a KML file.
1
vote
1answer
52 views

XLWT not writing to sheet in esri python add-in ArcMap 10.6

I have a tool I am converting to an ArcMap add-in. The problem is that the tool created a report and now the add-in report only contains the header row. I can't get the complete message box to fire at ...
2
votes
0answers
59 views

Excel-like, instant formulas in QGIS attribute table? [duplicate]

How to employ Excel-like, real time formulas in QGIS attribute table? As most of us know, in Excel changing input values in cells participating in formulas will change results instantaneously. In QGIS,...
0
votes
2answers
48 views

Exporting to Excel gives ERROR 000732?

I have a script that buffers a selected point, and intersects that buffer with features that the user inputs. I would like to convert the table outputted from the Intersect process into a excel file. ...
2
votes
1answer
28 views

Select by character limit

I'm using the select by attributes to find unique values that I am copy pasting from a spreedsheet. EX "jobnumber" = 1111116 OR "jobnumber" = 2222245 OR "jobnumber" = 5555655 .. etc The problem is ...
0
votes
2answers
70 views

Copy and paste certain cell characteristics of +500 cells in Excel at same time to create polygon shapefile? [closed]

We have this dataset with over >500 areas for which polygons are made. We don't know with which GPS these coordinates are registered. What we have is the Excel file with two columns. Cell A: "area ...
3
votes
2answers
320 views

How to create a polygon from Excel coordinate file

Currently I have an Excel file with 2 columns. area number. coordinates. The coordinate column contains several X and Y points those are seperated with a comma. Next an example how the points are ...
1
vote
2answers
32 views

Linking Excel Sheet to Point Data reference table using ArcMap?

I am trying to join an excel spreadsheet to the attribute table of project locations in ArcMap. The excel CSV file is in my layers and I can open and view it as an attribute table. However, it is ...
2
votes
0answers
67 views

How do I work with Excel and QGIS so that Excel formulas are intact when data is edited in QGIS?

I work a lot with Excel spreadsheets that are linked across multiple tabs and files. In this case, I have a sheet with coordinates and a whole lot of other data fields which needs to be imported into ...
2
votes
1answer
38 views

Format Coordinates Checker with QGIS or other Appilcations

I have thousand list coordinates from excel format (CSV file), its projection is Geographic WGS 84 (EPSG 4326) most of all. All of the coordinates are inserted manually from our surveyor teams. But ...
1
vote
0answers
48 views

Using ModelBuilder to Automatically Import Excel, Display XY and Append to Master Shapefile?

I'm trying to automate a daily workflow using ModelBuilder. I have several tasks that I do daily in this order: Import an Excel file that contains 16 fields including two fields with x and y ...
4
votes
2answers
225 views

Using vlookup function in ArcMap?

I am trying to automate a field calculation using ModelBuilder, using a GDB table to populate a feature class field given two conditions: Traffic Count Value and Posted Speed limit I have created ...
0
votes
1answer
28 views

Disappearing header

I am trying to perform a join on a zip code .shp and a table that contains the same GEOID10 zip code column along with some diagnosis counts by month/year. The fields for all the dx mo/yr columns ...
0
votes
0answers
87 views

Joining Excel file with shapefile

I am using QGIS version 2.18.19. I have created a shapefile using a script and its attribute table is empty as shown in below image. I am adding an Excel file. It includes a table as the input to the ...
-1
votes
1answer
137 views

Joining attribute table with excel file in QGIS? [closed]

I am using qgis version 2.18.19.I want to join excel file with the attribute table of a shape file.My attribute table has 1 row and 4 column.Excel file table has 1 column and 8 rows.I have experience ...
5
votes
4answers
557 views

Editing shapefile in Excel without losing points for ArcMap?

I have a point shapefile with a lot of data that needs to be cleaned up. I'd much prefer to work with the table in Excel. When I use the "Table to Excel" tool, I can get the data into Excel, but when ...
0
votes
3answers
45 views

Adding points to input point features option using spline method in ArcGIS Desktop?

I want to interpolate raster surface from points. I have excel file consisting of latitude, longitude and values( which I want to interpolate). How do I add these point values in input point feature ...
0
votes
0answers
16 views

Lost data in saving temp events to point layer. ArcGIS

I have imported an excel sheet and projected the xy coordinate information to a temporary events layer. When exported to a point layer half of the data in attribute table is missing e.g. the field ...
1
vote
1answer
36 views

Creating attribute tables and joining tables

I hope someone can help me! So I have multiple shapefiles and layers. I didn't give them an ID when I created them. But now that I have finished my drawings, I need to give them an id (?) and I need ...
0
votes
0answers
33 views

Is it possible to copy-paste a table from excel into an Activated data frame?

I am creating a map series via data driven pages, and need each map to have its own table. I know you can copy-paste excel tables directly into the mxd, however, when I try to activate the data frame ...
0
votes
1answer
80 views

Batch clipping with multiple shapefiles in ArcPy?

I am trying to create an ArcPy script to clip multiple shapefiles (2,000) to the census tracts in LA County. I have successfully run the code on a single shapefile and am trying to convert the code ...
0
votes
1answer
91 views

PyQGIS | Write in Excel [closed]

I wrote simple code to check the xlwt module in Qgis. But I receive an error. from xlwt import Workbook wb = Workbook() sheet1 = wb.add_sheet('Sheet 1') sheet1.write(0,0,'Hello!') wb.save("test12....
0
votes
0answers
41 views

Using Excel spreadsheet to allocate to polygons in ArcGIS Online web map

I have created a web map app with features of an outdoor event with camping pitches, the show organisers have an Excel spreadsheet with everyone who is camping my idea was for for them to enter ...
3
votes
1answer
235 views

Copy / paste table attribute qgis to excel lose colum order

When I copy data from a table attribute to excel the order of column is randomly. E.g. If in Qgis the order of column is column_a, column_b, column_c, column_d in excel is column_a, column_c, ...
1
vote
1answer
68 views

How to make a clickable label in qgis from an excel sheet?

I have location data in excel sheet where each label has corresponding data file for each financial year. I want it that when i click on a label, years pop up, and when i click on that year, its ...