Search Results

Search found 182 results on 8 pages for 'sathish reddy'.

Page 2/8 | < Previous Page | 1 2 3 4 5 6 7 8  | Next Page >

  • Handling "No cells were found." Error in Excel

    - by Sathish
    I am working on Excel VSTO application and finding error cells in the worksheets using the below code Excel.Range rngTemp; Excel.Range rngErrorRange; Excel._Worksheet Sheet1 = (Excel._Worksheet)xlCTA.Sheets["Sheet1"]; rngTemp = wsCTAWK11.UsedRange; rngErrorRange = rngTemp.SpecialCells(Excel.XlCellType.xlCellTypeFormulas, Excel.XlSpecialCellsValue.xlErrors); when there are really error cells found then i do not have any issues but when i dont have any error cells in these sheet i get the below exception **threw an exception of type 'System.Runtime.InteropServices.COMException' base {System.Runtime.InteropServices.ExternalException}: {"No cells were found."}** How to handle this... Pls help

    Read the article

  • Create a sub menu in existing menu in Excel Shared Add-in

    - by Sathish
    Hi I am developing a Excel shared Add-in which has the menu called Custom which is created using Excel Macros. Now i want to create a submenu under the Custom menu using Csharp Shared Add -in. Iam using the below code for doing this but no help oStandardBar = oCommandBars["Custom"]; oCmdBarCtrl = oStandardBar.Controls.Add(MsoControlType.msoControlPopup, Type.Missing, Type.Missing, Type.Missing, true); oCmdBarCtrl.Visible = false; oCmdBarCtrl.Caption = "Sub Menu1"; But it does not create a submenu, where as if i give "Help" in place of Custom i get the menu created. any work around for this?

    Read the article

  • GWT Dynamic loading using GWT.create() with String literals instead of Class literals

    - by Sathish
    GWT.create() is the reflection equivalent in GWT, But it take only class literals, not fully qualified String for the Class name. How do i dynamically create classes with Strings using GWT.create()? Its not possible according to many GWT forum posts but how is it being done in frameworks like Rocket-GWT (http://code.google.com/p/rocket-gwt/wiki/Ioc) and Gwittir (http://code.google.com/p/gwittir/wiki/Introspection)

    Read the article

  • Reading XML outer tables

    - by Sathish
    I have an Xml file as shown below in which if i convert this to Dataset, the dataset will contain 3 tables with talble names Table Name1, Table Name2 and Table Name3 but i want to get this information without converting this to dataset Basically i want to get all the outer table names out of my excel. Please help me with the piece of code <Main Table> <Table Name1> <Something> <Something> <Something> <Something> </Table Name1> <Table Name2> <Something> <Something> <Something> <Something> </Table Name2> <Table Name3> <Something> <Something> <Something> </Table Name3> </Main Table>

    Read the article

  • Appending data to Datatable

    - by Sathish
    I am adding data to a dataset using the below code cmdExcel.CommandText = "SELECT * FROM Table11" dr = cmdExcel.ExecuteReader(); DataTable dtExcel = new DataTable("WK11"); dtExcel.Load(dr); ds.Tables.Add(dtExcel); Now i want to add the content from Table2 to the same datatable WK11. Is it possible? cmdExcel.CommandText = "SELECT * FROM Table12" dr = cmdExcel.ExecuteReader(); dtExcel.Append(.....

    Read the article

  • Excel.Range.Find method

    - by Sathish
    I am using Excel interop object and trying to find a date in a specified range by below method Excel.Range rngFind = WS.get_Range(strFromRange, strToRange).Find(strFind, Type.Missing, Excel.XlFindLookIn.xlFormulas, Excel.XlLookAt.xlPart, Excel.XlSearchOrder.xlByRows, Excel.XlSearchDirection.xlNext, false, false, false); but i get rngFind as null always my strFind = "Sep-08" i tried with both Excel.XlFindLookIn.xlFormulas and Excel.XlFindLookIn.xlValues my excel file looks like this Sep-08 Oct-08 Nov-08 Dec-08 Jan-09 Feb-09 Mar-09 Apr-09 May-09 Jun-09 Jul-09 where as wheni click on Sep-08 cell i get 9/1/2008 in the formula field in Excel i have also tried searching for 9/1/2008 but it varies system by system as per the RegionalSettings Date format... Please help me. basically i am doing to get the cell address of the finding string

    Read the article

  • Cell value is read as #### in excel

    - by Sathish
    I am reading a cell value from excel using named range in my case sometime the column width is smaller then the value that is present in the cell and hence it is appearing as ##### when it is huge number. when i read this from csharp it is reading as #####. Any fix for this

    Read the article

  • Eclipse Debug Mode disrupting SQL Server 2005 Stored Procedure access

    - by Sathish
    We have a strange problem in our team. When a developer is using Eclipse in Debug mode, SQL Server 2005 blocks other developers from accessing a stored procedure. Debug session typically involves opening Hibernate session to persist an entity which could be accessing a stored procedure used for Primary key generation. Debugging is done in business logic code and rarely in JDBC stored procedure call. Is there any way to configure SQL server or the stored procedure so that other developers are not blocked?

    Read the article

  • Rotating sql table

    - by Sathish
    my sql talble has the following structure F1 F2 F3 F4 F5 Group 1 2 3 4 Design 5 6 7 8 now i want to read this and return a query result as show below please help F1 Value Group 1 Group 2 Group 3 Group 4 Design 5 Design 6 Design 7 Design 8

    Read the article

  • reading from app.config file

    - by Sathish
    I am trying to read StartingMonthColumn and CategoryHeadingColumn from the below app.config file using the code ConfigurationSettings.AppSettings["StartingMonthColumn"] but it is returning null, also ConfigurationSettings.AppSettings.Count returns zero Please help me to read this in my windows application <configuration> <configSections> <sectionGroup name="userSettings" type="System.Configuration.UserSettingsGroup, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" > <section name="CTARepository.Properties.Settings" type="System.Configuration.ClientSettingsSection, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" allowExeDefinition="MachineToLocalUser" requirePermission="false" /> </sectionGroup> </configSections> <userSettings> <CTARepository.Properties.Settings> <setting name="Setting" serializeAs="String"> <value /> </setting> </CTARepository.Properties.Settings> </userSettings> <appSettings> <add key="StartingMonthColumn" value="7"/> <add key="CategoryHeadingColumn" value="1"/> </appSettings>

    Read the article

  • Trimming the XML file

    - by Sathish
    I have a XML file as shown below <NewDataSet> - <T> <P /> <C>1</C> <M /> </T> - <T> <P /> <C>1</C> <M /> </T> - <T> <P /> <C>1</C> <M /> </T> - <T> <P /> <C>1</C> <M /> </T> - <T> <P /> <C>2</C> <M>44</M> </T> - <T> <P /> <C>2</C> <M>45</M> </T> - <T> <P /> <C>2</C> <M>46</M> </T> </NewDataSet> Question - Basicall i should remove the block <T> <P /> <C>1</C> <M /> </T> that does not have <M> Value

    Read the article

  • Displaying large file in JTextArea.

    - by Sathish Gopal
    Hi All, I'm currently working in Swing UI Assignment. This work involves showing large file content in JTextArea. The file size can be as large as 2 GB. My initial idea is to lazily load content from the file, say 1 MB of content will be shown to the user. As the user scrolls i will retrieve the next 1 MB of content to be shown. All these operation will be happening in background thread (Swing Worker). I looked at the JTextArea API, the method insert takes String and int(position of the insert) as the parameter. This will suffice, but i'm worried about performance, because the content (1 MB at a time) retrieved will have to be converted to String object. Is there any other work around or any other alternative/better solution for this.

    Read the article

  • Eclipse plugin to find the error on Double Click the file

    - by sathish
    Hi, I need the help in console view of eclipse. When i build my project all my errors and warnings are displayed in console window and if i need to find the place where it showing those errors i need have to go into that file and find those information. I feel its much iritating to find when errors are huge. So is there any plugin available that take us to that location of errors on double click. Thanks in Advance

    Read the article

  • get username from Webservice

    - by Sathish
    Hi How can i get the username from the webservice my Webservice is configured under Enterprise sign on authentication. I am using the below code for webapplication Request.ServerVariables("HTTP_CT_REMOTE_USER") and i need a equavelent for webservices Context.Request.ServerVariables["HTTP_CT_REMOTE_USER"] returns null for me

    Read the article

  • Read widnows event logs using Enterprise library

    - by Sathish
    I am using Enterprise library 3.1 to log application logs in Windows event logs and i want to read this logs by passing the date parameter. Please note that i will be accessing the remote machine and the performance should be good. Is there any method that can be used to read these logs using Ent Lib... or Please suggest some good method.

    Read the article

  • Encyption in DATA access block

    - by Sathish
    I am using enterprise library DATA access block in my application and now i want to Encrypt the connection string and store it in the Config file and consume it in my application after decrypting the same. How can i do this

    Read the article

  • SQL Bulkcopy using DATA Access block

    - by Sathish
    I am using the below piece of code for SQL Bulk copy using (SqlConnection con = new SqlConnection(strConString)) { con.Open(); SqlBulkCopy sqlBC = new SqlBulkCopy(con); sqlBC.DestinationTableName = "SomeTable"; sqlBC.WriteToServer(dtOppConSummary); } Can anyone provide me the equvalent code using Data access block Enterprise library

    Read the article

  • Reading XML by Dataset

    - by Sathish
    I using a dataset to read an xml file as shown below DataSet ds = new DataSet(); ds.ReadXml("C:\test.xml"); test.xml contains OMID Yes AssumptOMID int 10 ClientName Yes AssumptClient string 50 OppName Yes AssumptProjectName string 50 now i want to read fieldInfo in one dataset/datatable and settings in another dataset/datatable Please help me with the code

    Read the article

  • Null Safe dereferencing in Java like ?. in Groovy using Maybe monad

    - by Sathish
    I'm working on a codebase ported from Objective C to Java. There are several usages of method chaining without nullchecks dog.collar().tag().name() I was looking for something similar to safe-dereferencing operator ?. in Groovy instead of having nullchecks dog.collar?.tag?.name This led to Maybe monad to have the notion of Nothing instead of Null. But all the implementations of Nothing i came across throw exception when value is accessed which still doesn't solve the chaining problem. I made Nothing return a mock, which behaves like NullObject pattern. But it solves the chaining problem. Is there anything wrong with this implementation of Nothing? [http://github.com/sathish316/jsafederef/blob/master/src/s2k/util/safederef/Nothing.java] As far as i can see 1. It feels odd to use mocking library in code 2. It doesn't stop at the first null. 3. How do i distinguish between null result because of null reference or name actually being null? How is it distinguished in Groovy code?

    Read the article

< Previous Page | 1 2 3 4 5 6 7 8  | Next Page >