We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

how to create dropdown box(validation value range from another sheet)

Thread ID:





39963 Jan 22,2006 02:23 PM UTC Jan 25,2006 06:13 AM UTC WinForms 3
Tags: XlsIO
Asked On January 22, 2006 02:23 PM UTC

hi, guys, I am using Syncfusion ExcelRW now. I try to create a dropdown list with certain values, those values are defined in cells in one column in another sheet, how can I do that? I know how to make a dropdown list with values from a string array in my program, but seems the same function didn''t allow me to put the cells'' position. Thanks a lot for your help.

Ramu [Syncfusion]
Replied On January 23, 2006 03:02 PM UTC

Hi Michael, Here is the sample that adds value to the dropdown list from the worksheet. sample Thank you for your interest in Syncfusion products. Thanks, Ramu.

Administrator [Syncfusion]
Replied On January 24, 2006 09:11 PM UTC

thanks, Ramu, it worked. Btw, do you know how to set the sheet''s "visibility" as "hide", so end user cannot see it, but my other sheets can pull the values from it. thanks again. Michael

Ramu [Syncfusion]
Replied On January 25, 2006 06:13 AM UTC

Hi Michael, Here is the sample that hides the sheet in workbook and to retrieve data from hidden sheet. You could also unhide the hidden sheet in workbook. Sample code: //Hiding the first sheet in the workbook. sheet.Visibility =WorksheetVisibility.Hidden; //Data in hidden sheet. sheet.Range ["A1"].Text ="Hidden sheet"; for(int i=2;i<=10;i++) { sheet.Range [i,1].Text ="Value"+ (i-1).ToString (); } IRange rang=sheet.Range ["A1:A5"]; IRange rang1=sheet1.Range ["A2:A6"]; sheet1.Range["A1"].Text ="Value from hidden sheet"; //Reading value from Hidden Sheet. rang.CopyTo (rang1); Please let me know if you have any questions. Thanks, Ramu. HideSheetInWorkbook.zip


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon