Spread for silverlight 数据校验

怎么样在Spread for silverlight 7.0 中 实现excel 批量导入后的数据上传，请各位大牛指点！

回复 1楼songhx的帖子

“怎么样在Spread for silverlight 7.0 中 实现excel 批量导入后的数据上传，”

刚才我们通过电话，数据上传指的是什么？数据校验还是？

感觉问题和我们刚才沟通的不太符合。

版主，不好意思，“数据上传”指的就是咱们沟通的“数据校验”

回复 3楼songhx的帖子

你好，感谢反馈。我理解问题分为以下两个步骤：
1.使用 Spread 打开 Excel，可以参考：
http://demo.gcpowertools.com.cn/ ... tml#ExcelIE/ExcelIE

2.对特定单元格进行数据校验,详细可以参考帮助文档：Using Data Validation部分，下面是校验测试代码：

C#

1. 
   
2. gcSpreadSheet1.HighlightInvalidData = true;
   
3. var valid = GrapeCity.Windows.SpreadSheet.Data.DataValidator.CreateListValidator("5,10,15,20");            
   
4. gcSpreadSheet1.Sheets[0].Cells[0, 1].DataValidator = valid;
   
5. gcSpreadSheet1.Sheets[0].Cells[0, 0].Text = "5, 10, 15, and 20 are valid numbers.";
   
6.             
   
7. var valid1 = GrapeCity.Windows.SpreadSheet.Data.DataValidator.CreateNumberValidator(GrapeCity.Windows.SpreadSheet.Data.ComparisonOperator.GreaterThan, "5", "20", true);
   
8. gcSpreadSheet1.Sheets[0].Cells[1, 1].DataValidator = valid1;
   
9. gcSpreadSheet1.Sheets[0].Cells[1,0].Text = "A number greater than 5 is valid.";
   
10. 
    
11. var valid2 = GrapeCity.Windows.SpreadSheet.Data.DataValidator.CreateTextLengthValidator(GrapeCity.Windows.SpreadSheet.Data.ComparisonOperator.GreaterThan, "4", "20");            
    
12. gcSpreadSheet1.Sheets[0].Cells[2, 1].DataValidator = valid2;
    
13. gcSpreadSheet1.Sheets[0].Cells[2, 0].Text = "Type more than four characters.";
    
14. 
    

复制代码

VB.NET

1. 
   
2. GcSpreadSheet1.HighlightInvalidData = True
   
3. Dim valid = GrapeCity.Windows.SpreadSheet.Data.DataValidator.CreateListValidator("5,10,15,20")
   
4. GcSpreadSheet1.Sheets(0).Cells(0, 1).DataValidator = valid
   
5. GcSpreadSheet1.Sheets(0).Cells(0, 0).Text = "5, 10, 15, and 20 are valid numbers."
   
6. 
   
7. Dim valid1 = GrapeCity.Windows.SpreadSheet.Data.DataValidator.CreateNumberValidator(GrapeCity.Windows.SpreadSheet.Data.ComparisonOperator.GreaterThan, "5", "20", True)
   
8. GcSpreadSheet1.Sheets(0).Cells(1, 1).DataValidator = valid1
   
9. GcSpreadSheet1.Sheets(0).Cells(1, 0).Text = "A number greater than 5 is valid."
   
10. 
    
11. Dim valid2 = GrapeCity.Windows.SpreadSheet.Data.DataValidator.CreateTextLengthValidator(GrapeCity.Windows.SpreadSheet.Data.ComparisonOperator.GreaterThan, "4", "20")
    
12. GcSpreadSheet1.Sheets(0).Cells(2, 1).DataValidator = valid2
    
13. GcSpreadSheet1.Sheets(0).Cells(2, 0).Text = "Type more than four characters."
    
14. 
    

复制代码

回复 3楼songhx的帖子

请问问题是否解决？为了给你提供更优质的服务，请对本次服务进行评分。我们会认真对待你提出的宝贵意见，谢谢