Import functionality should look through an Excel workbook to allow the user to select which worksheet to import

[dfoll]

Current behavior

Using the add-in to import an Excel file only allows the user to select a workbook. By default the first worksheet in the workbook is the one used for import.

Expected behavior

The add-in should allow the user to select which worksheet they want to import from a workbook. ArcGIS natively allows the user to search through a workbook when adding data, however the add-in only allows the user to select a workbook.

[dfoll]

Excel to table does not allow user to easily select a sheet

• decision needed if we want to expose the optional text box. there is no known risk in exposing the text other than typos in input, it can still be left blank to select the first sheet (this is how our tool works now, that option is not even exposed and thus blank). one thing to keep in mind is there will be no way for the user to select which sheet they want.

If we want to populate the list of sheets we need to revert our decision to use the gp tool and use npoi or interop. if we use the interop option, there will be a requirement for excel to be installed.

[dfoll]

For this release we will match the functionality of the gp tool that is used. We will allow the user to explicitly specify a worksheet. The ability to select a worksheet by browsing is something we will evaluate in the future.

[dfoll]

We are not currently going to add the functionality to browse to/use as specific worksheet. We will add a note that when using a .xlsx that the first worksheet in the workbook is the one that is imported. Possibly add to the note that the user can use the core tool if they must use a worksheet that is not the first one.

Issue will be closed once note is added

reason for strikeouts is here

[dfoll]

• [x] version topic
• [x] update topic
• [x] update CC workflows pub with new version
• [x] republish CC workflows
• [x] update CC pdf with new version
• [x] republish CC pdf
• [x] rebuild CC
• [x] update MT workflows pub with new version
• [x] republish MT workflows
• [x] update MT pdf version
• [x] republish MT pdf
• [x] rebuild MT

[dfoll]

Leaving this open temporarily while we get confirmation about the level of effort for allowing a user to browse to a specific worksheet.

• ideal scenario is that when a user browses to a workbook the first sheet is used by default or
• the user can go one step further to select a sheet.

I had discussions with @saip about this in the past, but the reason we cannot do this is currently escaping me, leaving open until we get clarification.

@csmoore for awareness or any possible input

[dfoll]

Doc QC work:

• [x] Coordinate Conversion Workflows
• [x] \DefenseSolutions\CoordinateConversion\October2019\Dev\170\
• [x] Military Tools Workflows
• [x] \DefenseSolutions\MilitaryToolsforArcGIS\October2019\Dev\343\

[lfunkhouser]

Verified note added to Import coordinates topic: When importing a .xls/.xlsx file the first sheet in the workbook is used as input.

Verified on Dev site for CC and MT and PDFs CC 175 and MT 345

Reopening... https://github.com/Esri/coordinate-conversion-addin-dotnet/issues/588#issuecomment-534754376

[dfoll]

"As designed" the functionality is not designed to be able to use a sheet from a workbook other than the first sheet. If a user brings to us a need to use a sheet that is not the first sheet in a workbook and the work around of editing the workbook to make it the first sheet is not an option, we will open a new issue for that functionality at that time