Add Named Range to Excel using C# -

-

I am creating excel sheet which is named after the class created using code. 

  ExcelRange namedRange = Sheet1 Seals [2, Startcollum + i, Region Andrra, Start column + I]; Package. Workbook Name. Add ("Named Range", Named Range); namedRange.Dispose ();   
 After saving the axle file, I am trying to open the file. At that time it gives me an error like  
    
 Is there a clue to this problem  
 
 
 
 I To find the reason I am using this designated category by adding this code more dynamically to a loop. There are some names with spaces in some time & amp; Character for the category name. The same problem is when it is opening the sheet, all named categories will be abandoned which are invalid

Comments

Post a Comment

Popular posts from this blog

c# - Roxy file manager in MVC doesn't accept session path -

-
Hi friends I've downloaded a file manager for my MVC project. So I added to my project and everything works fine but everyone can use this product I mean everyone can type urls and upload files to my host !!!! This filemanager has a Jason config file, as you can see here: {"FILES_ROOT": "Fileman / Upload "," "File_type_kenny": "file", "THUMBS_VIEW_WIDTH": "140", "THUMBS_VIEW_HEIGHT": "120", "PREVIEW_THUMB_WIDTH": "300", "PREVIEW_THUMB_HEIGHT": "200", "MAX_IMAGE_WIDTH": "0" "ASP_net / Main.Shex? A = Created", " Dealederer ":" ASP_net / MAN.assx "ADELEDED IR "," MOVEDIR ":" ASP_net / Main.Shex? A = MoVEDIR "," Copdier ":" ASP_net / Main.Shex? A = Copdier "," Richie Dar ":" ASP_net / Main ASP_net / main.hex? A = Upload "," Downlo...
Read more

php - proc_open Too many open files in long running Symfony Console app -

-
I have created a console app with a SIM console console component. It was going to run for 5 hours but after running 2 hours I have a proc_open (): Many open files in the pipeline error Symfony \ Component \ Console \ Application.php On-line 985. I tried to gc_collect_cycles in my code, but got the same error. Is this a Symphonic Console component bug or should I not run any app for this long time (but I have to)? This problem relates to: Obviously you have many resources in your app It's not a symphony console bug, but it's a PHP bug. You can modify your program by using another programming language to open fewer files.
Read more

c# - Show a huge number of data in DevExpress GridView -

-
With 3000 lines I have a DevExpress grid view and each row has 10 as extensions (this means that when I have 30000 loads in grid load items to load) All data loads It takes a long time to do so, then there is a way to show example 100 lines, and when I use the automatic filter, do I show the lines I want? Example I tried to leave and take (using LINQ), but what I actually see for it Also want to use the automatic filter of the grid. Public Static Binding List & lt; Patient & gt; GetObjectUsingLinq (string sql = "", int skipCount = 0, int lekton = 0) {var gsData = GetDataContext (); Var query = (to choose q.nom q with GS dataApotate order); Return new compulsory list & lt; Patient & gt; (LinqHelper.DoSortPaginate (Query, "" Leave, Techcount) .Oolist ()); } and to call it on the grid listPatient = patients.getObjectUsingLinq (); myGrid.DataSource = listPatient; If you need to display large amounts of records in the grid control, ...
Read more