Hi, I'm a new with both C# and Pro SDK. I have to convert my vb.net ArcMap addin to Pro. I'm taking baby steps here so please bear with me. Today I'm trying to write codes for the addin for user to open an excel file and import a column to a list view which I put inside a dockpane. I got errors at lstviewAllAcct.View = View.Details; //error: View does not exist in the current context lstviewAllAcct.GridLines = true; //error: 'ListView' does not contain a definition for GridLines and no accessible extension method lstviewAllAcct.FullRowSelect = true; //error: same as above How to I access the properties of my listview? Thanks for your help. using ArcGIS . Desktop . Catalog ; using Microsoft . Win32 ; using OfficeOpenXml ; //reference EPPlus (excelpackage) using System ; using System . Collections . Generic ; using System . Linq ; using System . Text ; using System . Threading . Tasks ; using System . Windows ; using System . Windows . Controls ; using System . Windows . Data ; using System . Windows . Documents ; using System . Windows . Input ; using System . Windows . Media ; using System . Windows . Media . Imaging ; using System . Windows . Navigation ; using System . Windows . Shapes ; namespace ProAppApril92 { /// /// Interaction logic for Dockpane1View.xaml /// public partial class Dockpane1View : UserControl { public Dockpane1View ( ) { InitializeComponent ( ) ; } private void BtnOpenExcelFile_Click ( object sender , RoutedEventArgs e ) { Microsoft . Win32 . OpenFileDialog openFileDialog1 = new OpenFileDialog ( ) ; openFileDialog1 . InitialDirectory = @"c:\"; openFileDialog1.Filter = " XLSX Files ( * . xlsx ) | * . xlsx | XLS Files ( * . xls ) | * . xls | All files ( * . * ) | * . * " ; openFileDialog1 . FilterIndex = 1 ; openFileDialog1 . RestoreDirectory = true ; openFileDialog1 . ShowDialog ( ) ; var package = new ExcelPackage ( ) ; var workbook = package . Workbook ; if ( workbook != null ) { var sheet = workbook . Worksheets [ 1 ] ; var firstColumnRows = sheet . Cells [ "A1:A" ] ; object cell ; lstviewAllAcct . View = View . Details ; lstviewAllAcct . GridLines = true ; lstviewAllAcct . FullRowSelect = true ; } else System . Windows . MessageBox . Show ( openFileDialog1 . Title ) ; } } }

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Access listview inside dockpane

helenchu

Hi,

I'm a new with both C# and Pro SDK. I have to convert my vb.net ArcMap addin to Pro. I'm taking baby steps here so please bear with me. Today I'm trying to write codes for the addin for user to open an excel file and import a column to a list view which I put inside a dockpane.

I got errors at

lstviewAllAcct.View = View.Details; //error: View does not exist in the current context
lstviewAllAcct.GridLines = true; //error: 'ListView' does not contain a definition for

GridLines and no accessible extension method
lstviewAllAcct.FullRowSelect = true; //error: same as above

How to I access the properties of my listview? Thanks for your help.

<SPAN class="keyword token">using</SPAN> ArcGIS<SPAN class="punctuation token">.</SPAN>Desktop<SPAN class="punctuation token">.</SPAN>Catalog<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">using</SPAN> Microsoft<SPAN class="punctuation token">.</SPAN>Win32<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">using</SPAN> OfficeOpenXml<SPAN class="punctuation token">;</SPAN> <SPAN class="comment token">//reference EPPlus (excelpackage)</SPAN>
<SPAN class="keyword token">using</SPAN> System<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">using</SPAN> System<SPAN class="punctuation token">.</SPAN>Collections<SPAN class="punctuation token">.</SPAN>Generic<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">using</SPAN> System<SPAN class="punctuation token">.</SPAN>Linq<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">using</SPAN> System<SPAN class="punctuation token">.</SPAN>Text<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">using</SPAN> System<SPAN class="punctuation token">.</SPAN>Threading<SPAN class="punctuation token">.</SPAN>Tasks<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">using</SPAN> System<SPAN class="punctuation token">.</SPAN>Windows<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">using</SPAN> System<SPAN class="punctuation token">.</SPAN>Windows<SPAN class="punctuation token">.</SPAN>Controls<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">using</SPAN> System<SPAN class="punctuation token">.</SPAN>Windows<SPAN class="punctuation token">.</SPAN>Data<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">using</SPAN> System<SPAN class="punctuation token">.</SPAN>Windows<SPAN class="punctuation token">.</SPAN>Documents<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">using</SPAN> System<SPAN class="punctuation token">.</SPAN>Windows<SPAN class="punctuation token">.</SPAN>Input<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">using</SPAN> System<SPAN class="punctuation token">.</SPAN>Windows<SPAN class="punctuation token">.</SPAN>Media<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">using</SPAN> System<SPAN class="punctuation token">.</SPAN>Windows<SPAN class="punctuation token">.</SPAN>Media<SPAN class="punctuation token">.</SPAN>Imaging<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">using</SPAN> System<SPAN class="punctuation token">.</SPAN>Windows<SPAN class="punctuation token">.</SPAN>Navigation<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">using</SPAN> System<SPAN class="punctuation token">.</SPAN>Windows<SPAN class="punctuation token">.</SPAN>Shapes<SPAN class="punctuation token">;</SPAN>


<SPAN class="keyword token">namespace</SPAN> ProAppApril92
<SPAN class="punctuation token">{</SPAN>
    <SPAN class="comment token">/// <summary></SPAN>
    <SPAN class="comment token">/// Interaction logic for Dockpane1View.xaml</SPAN>
    <SPAN class="comment token">/// </summary></SPAN>
    <SPAN class="keyword token">public</SPAN> <SPAN class="keyword token">partial</SPAN> <SPAN class="keyword token">class</SPAN> <SPAN class="token class-name">Dockpane1View</SPAN> <SPAN class="punctuation token">:</SPAN> UserControl
    <SPAN class="punctuation token">{</SPAN>
        <SPAN class="keyword token">public</SPAN> <SPAN class="token function">Dockpane1View</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
        <SPAN class="punctuation token">{</SPAN>
            <SPAN class="token function">InitializeComponent</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
        <SPAN class="punctuation token">}</SPAN>

        <SPAN class="keyword token">private</SPAN> <SPAN class="keyword token">void</SPAN> <SPAN class="token function">BtnOpenExcelFile_Click</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">object</SPAN> sender<SPAN class="punctuation token">,</SPAN> RoutedEventArgs e<SPAN class="punctuation token">)</SPAN>
        <SPAN class="punctuation token">{</SPAN>
            Microsoft<SPAN class="punctuation token">.</SPAN>Win32<SPAN class="punctuation token">.</SPAN>OpenFileDialog openFileDialog1 <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">OpenFileDialog</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
            openFileDialog1<SPAN class="punctuation token">.</SPAN>InitialDirectory <SPAN class="operator token">=</SPAN> <SPAN class="string token">@"c:\";
            openFileDialog1.Filter = "</SPAN>XLSX Files <SPAN class="punctuation token">(</SPAN><SPAN class="operator token">*</SPAN><SPAN class="punctuation token">.</SPAN>xlsx<SPAN class="punctuation token">)</SPAN><SPAN class="operator token">|</SPAN><SPAN class="operator token">*</SPAN><SPAN class="punctuation token">.</SPAN>xlsx<SPAN class="operator token">|</SPAN>XLS Files <SPAN class="punctuation token">(</SPAN><SPAN class="operator token">*</SPAN><SPAN class="punctuation token">.</SPAN>xls<SPAN class="punctuation token">)</SPAN><SPAN class="operator token">|</SPAN><SPAN class="operator token">*</SPAN><SPAN class="punctuation token">.</SPAN>xls<SPAN class="operator token">|</SPAN>All files <SPAN class="punctuation token">(</SPAN><SPAN class="operator token">*</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="operator token">*</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="operator token">|</SPAN><SPAN class="operator token">*</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="operator token">*</SPAN>"<SPAN class="punctuation token">;</SPAN>
            openFileDialog1<SPAN class="punctuation token">.</SPAN>FilterIndex <SPAN class="operator token">=</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">;</SPAN>
            openFileDialog1<SPAN class="punctuation token">.</SPAN>RestoreDirectory <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">true</SPAN><SPAN class="punctuation token">;</SPAN>
            openFileDialog1<SPAN class="punctuation token">.</SPAN><SPAN class="token function">ShowDialog</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

            <SPAN class="keyword token">var</SPAN> package <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">ExcelPackage</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
            <SPAN class="keyword token">var</SPAN> workbook <SPAN class="operator token">=</SPAN> package<SPAN class="punctuation token">.</SPAN>Workbook<SPAN class="punctuation token">;</SPAN>
            <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>workbook <SPAN class="operator token">!=</SPAN> <SPAN class="keyword token">null</SPAN><SPAN class="punctuation token">)</SPAN>
            <SPAN class="punctuation token">{</SPAN>
                <SPAN class="keyword token">var</SPAN> sheet <SPAN class="operator token">=</SPAN> workbook<SPAN class="punctuation token">.</SPAN>Worksheets<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">;</SPAN>
                <SPAN class="keyword token">var</SPAN> firstColumnRows <SPAN class="operator token">=</SPAN> sheet<SPAN class="punctuation token">.</SPAN>Cells<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"A1:A"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">;</SPAN> 
                <SPAN class="keyword token">object</SPAN> cell<SPAN class="punctuation token">;</SPAN>
                lstviewAllAcct<SPAN class="punctuation token">.</SPAN>View <SPAN class="operator token">=</SPAN> View<SPAN class="punctuation token">.</SPAN>Details<SPAN class="punctuation token">;</SPAN>
                lstviewAllAcct<SPAN class="punctuation token">.</SPAN>GridLines <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">true</SPAN><SPAN class="punctuation token">;</SPAN>
                lstviewAllAcct<SPAN class="punctuation token">.</SPAN>FullRowSelect <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">true</SPAN><SPAN class="punctuation token">;</SPAN>
            <SPAN class="punctuation token">}</SPAN>

            <SPAN class="keyword token">else</SPAN>
                System<SPAN class="punctuation token">.</SPAN>Windows<SPAN class="punctuation token">.</SPAN>MessageBox<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Show</SPAN><SPAN class="punctuation token">(</SPAN>openFileDialog1<SPAN class="punctuation token">.</SPAN>Title<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
        <SPAN class="punctuation token">}</SPAN>
    <SPAN class="punctuation token">}</SPAN>

  
<SPAN class="punctuation token">}</SPAN>
<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Trouver plus de publications taguées avec

Accepted answers

Wolf

Hi Helen,

I am attaching a sample project for you that demonstrates how to populate a listbox with two columns using the first two columns of a spreadsheet. I think this is a useful sample and I will add it with the next release to the community samples. The add-in looks for a .csv file that I included in the project source as well (it's called Meteorites_UK.csv). You can read any file that can be opened with Excel with this code but you have to match the sheet name and column count. To run the add-in, open the "Show Spreadsheet" dockpane, then use the "import csv" button to browse to Meteorites_UK.csv.

Once you click "Open" on the input selection dialog you see the listbox getting populated.

If you look at ShowSpreadsheet.xaml you find that the listview is bound to two properties: SpreadSheetRows for the ItemsSource and SelectedSpreadSheetRow for the SelectedItem attributes. If you then look in the code behind file ShowSpreadsheetViewModel.cs you see the appropriate properties that match these 'bindings':

<SPAN class="keyword token">public</SPAN> ObservableCollection<SPAN class="operator token"><</SPAN>SpreadSheetColumns<SPAN class="operator token">></SPAN> SpreadSheetRows‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

and

 <SPAN class="keyword token">public</SPAN> SpreadSheetColumns SelectedSpreadSheetRow‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

When you look at these properties you will notice that both are using 'SetProperty' in the setter. 'SetProperty' is important because it initiates the notification mechanism that notifies the UI when one of these properties is changed (or 'set'). This mechanism is called data binding and you can read up on it if you search for 'WPF data binding'.

Anyways I hope this sample helps.

ReadViaExcel.zip

All comments

helenchu

Thank you so very much Wolfgang.

Wolf

Hi Helen,

Once you click "Open" on the input selection dialog you see the listbox getting populated.

<SPAN class="keyword token">public</SPAN> ObservableCollection<SPAN class="operator token"><</SPAN>SpreadSheetColumns<SPAN class="operator token">></SPAN> SpreadSheetRows‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

and

 <SPAN class="keyword token">public</SPAN> SpreadSheetColumns SelectedSpreadSheetRow‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

Anyways I hope this sample helps.

ReadViaExcel.zip

helenchu

Hi Wolfgang,

I've been studying the sample you suggested. I understand it a bit more but I'm still pvery much in dark. Hopefully you can shed some more light on me.

I find case of textbox, it uses <TextBox Text="{Binding ItemID}"> in .xaml file, to bind the data returned from the codes in Dockpane1ViewModel.cs .

My case I have to use listview to list all lines returned from excel. Which property of listview should I use for binding in .xaml file ?

And many properties like View = View.Details; GridLines = true; FullRowSelect = true are not available in .xaml too.

Your help is greatly appreciated.

---codes from my arcmap addin---------------

Dim workbook = package.Workbook
If workbook IsNot Nothing Then
Dim sheet = workbook.Worksheets(1)
Dim firstColumnRows = sheet.Cells("A1:A") ' Loop through rows in the first column, get values based on offset
Dim cell As Object
myForm.lstAllAcct.View = View.Details
myForm.lstAllAcct.Clear()

myForm.lstAllAcct.Columns.Add("Account Number", 122)

For Each cell In firstColumnRows
Dim column1CellValue = cell.GetValue(Of String)()
lvItem = myForm.lstAllAcct.Items.Add(Trim(column1CellValue.ToString))
Next
End If

-----------------------------------------------------------

helenchu

Thank you very much. I'll work on it and keep you posted. I still can't wrap my brain around this. Addin for Arcmap was a lot more straight forward to me.

Wolf

When you implement a dockpane using the Pro SDK it supports MVVM (Model - View - ViewModel) out of box. You can check out this video (starting at minute 20:00 of the video) to get an overview of MVVM in the Pro SDK: https://www.youtube.com/watch?v=5PgaeZycWXc

What this means is that the Pro SDK Item Template for DockPanes creates multiple files in support of MVVM for you. These files are used for:

The View (or UI): Dockpane1.xaml (and included with the XAML is the usually hidden Dockpane1.cs file containing the partial class implementation of the Dockpane1View / UserControl class). If you make any changes to the View you ONLY make these changes in XAML. You would not make any changes in the code behind for the View (Dockpane1View.cs file) when you are coding using the MVVM programming pattern .
The ViewModel (or business logic, code behind): Dockpane1ViewModel.cs contains the actual business logic and the properties to exchange data at runtime with the View using data binding. In MVVM this is were all code (business logic) goes, including the properties (which must be public) that are 'data bound' to the View (UI implemented in XAML)

Looking at your code snippet I see that you mixed MVVM with a non MVVM pattern. To implemented a command using the MVVM pattern, you have to utilize what is known as the ICommand pattern. There a plenty of examples under the Pro SDK community sample github repo, but you can search for BrowseCommand in the UploadItem sample and you find the XAML implementation here:

arcgis-pro-sdk-community-samples/UploadItem.xaml at f5f9dda18efa173a56d128f3ea64ca34ac3f68a9 · Esri/arcgis-pro-sdk-commu…

and the business logic for the BrowseCommand button is here:

arcgis-pro-sdk-community-samples/UploadItemViewModel.cs at f5f9dda18efa173a56d128f3ea64ca34ac3f68a9 · Esri/arcgis-pro-sd…

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.