Search Results

Search found 5148 results on 206 pages for 'excel macro'.

Page 157/206 | < Previous Page | 153 154 155 156 157 158 159 160 161 162 163 164  | Next Page >

• How can I destroy COM objects in C#?

  - by peril brain

  What are the methods to destroy Excel COM Interop objects in C#, besides these: object_instance = null; System.GC.collect(); Please suggest only inbuilt techniques, not other tools like bigcannon, etc.

  Read the article

• Find Missing Records

  - by Lennie De Villiers

  Hi, My SQL is a bit bad. I got a query that when I run it I return for example 10 rows but there are 15 in my where clause, how do I identify those 5 that I can't find? Off course I can dump it in MS Excel but how do I use SQL?

  Read the article

• Light and simple bugtracker for a small team

  - by Varnenchik

  I'm looking for a simple and light tool for tracking ideas and bugs for small physics lab team (4 members). Bugzilla and Trac have too much fields and other stuff for us. I don’t think that we need more than issue descriptions and simple categorization. But we are not happy with text and excel files suggested here. Could you please advise me anything easy to install preferably?

  Read the article

• Adding menus in WindowActivate Event

  - by Sathish

  I am designing a Shared Add-in for Excel in Csharp and now i am adding the custom menu in OnStartupComplete event but now i want this to be moved to WindowActivate event. I have added the event but it is not firing. Please help me

  Read the article

• How do I calculate percentiles with python/numpy?

  - by Uri

  Is there a convenient way to calculate percentiles for a sequence or single-dimensional numpy array? I am looking for something similar to Excel's percentile function. I looked in NumPy's statistics reference, and couldn't find this. All I could find is the median (50th percentile), but not something more specific.

  Read the article

• extracting only unique row from csv based on multiple column criteria ?

  - by wefwgeweg

  basically i have rows after rows of data event | venue | date | some | other | columns | here| there are lot of overlapping event that happens at same venue and date. so i would like to end up with only unique events by matching event, venue, date. is this possible in excel , how to approach this ? VBA ? or some option i dont know about ? thank you.

  Read the article

• What is the best way to detect if my page needs saving - ussing WPF MVVM

  - by Eli Perpinyal

  I have an application where you can open many different items (like in excel you can open many different tabs) If an item or "tab" is modified I want to detect the changes and allow the use to save or prompt if the user closes without saving. Maybe enable/disabling save button when a save is available/not available. I am using c# WPF with MVVM pattern.

  Read the article

• How can I extract parts of this filename in Perl?

  - by devtech

  In my Excel sheet with column Changeset I am getting the changeset like: C:\ccviews\hgdasdff-9302\dfcsz\ahgrt\kjhssl\ASGHLS@@\main\ajsdkljlat\hahdasdhfk\1\test.txt\sub\hsdaklfl\3 I need to use split function in a Perl script so that there will be two ouput (input as the above string) the part before @@ (e.g-here C:\ccviews\hgdasdff-9302\dfcsz\ahgrt\kjhssl\ASGHLS) the last character of the string (e.g-here 3)

  Read the article

• Capture output value from a shell command in VBA ?

  - by asksuperuser

  Found this function http://www.cpearson.com/excel/ShellAndWait.aspx But would need also to capture output from the shell output. Any code suggestion ?

  Read the article

• protecting non .aspx pages with Asp.net Membership provider

  - by Dave

  I'm currently using the asp.net membership provider (with logins stored in db) to protect certain pages of my site. However, I also have non .aspx resources I wish to protect - word docs, excel spreadsheets, pdfs, etc. Is this even possible? If so how would I go about doing this? thanks!

  Read the article

• jira plugin format issue

  - by zapping

  Does anybody know which date format is to be used, trying to create a plugin that generates a report that can be exported to excel or pdf.

  Read the article

• Check for hung Office process when using Office Automation

  - by Rob

  Is there a way to check to see if an Microsoft Office process (i.e. Word, Excel) has hung when using Office Automation? Additionally, if the process is hung, is there a way to terminate it?

  Read the article

• Need ad-hoc reporting component

  - by Nelson

  We need some simple ad-hoc reporting solution for our ASP.NET web-site. Just an ability to build a query with user friendly interface, then show the result of this query in some table and maybe export it to Excel or print. The solution must be quite easy for end users (our site visitors) who know nothing about databases, SQL and other tech stuff.

  Read the article

• Django save method

  - by Marijus

  So I have a model with a FileField for excel spreadsheet. What I need to do this add another column in this spreadsheet, in each row let user pick from a drop-down list then save it and display it in html. All the picking and uploading will happen through the admin interface. So I have figured out way how to display a spreadsheet in html, however I have no idea how to write this save method. I could really use some hints and tips..

  Read the article

• How can I make a web-based "table" select like a spreadsheet? (rectangular area vs row-wrap selecti

  - by Dax

  I want to make a table that displays on a webpage, but one requirement is to make it easy to copy and paste into a spreadsheet. Normal HTML tables selection behavior is obviously different from how a spreadsheet like Excel selects -- when you select multiple rows it wraps around instead of selecting a rectangular area. Is there any way to make HTML table behave like a spreadsheet in this regard, or is the only way to resort to a Flash table or something similar?

  Read the article

• Why W3C CSS Validator showing parsing error on "Ends-with" Attribute Value Selector

  - by metal-gear-solid

  Why W3C Validator showing parsing error on this. I selected CSS3 profile also from dropdown. a[href $=.xls]{background: transparent url(ms-excel-icon.gif) left top no-repeat; padding-left: 22px;display: block;height: 16px;}

  Read the article

• Do we have any Equivalent of Response.AppendHeader in windows application

  - by cmrhema

  Hi, I came around this technique of converting datatable to excel http://www26.brinkster.com/mvark/dyna/downloadasexcel.html Do we have any Equivalent of Response.AppendHeader in windows application in C#. Regards Hema

  Read the article

• VBA Or .Net Framework?

  - by hosseinsinohe

  Hi All I Want Develop And Automat Office Softwares like 'Microsoft Excel 2007' And 'Microsoft Word 2007' .But I do not know Use VBA or Use C Sharp Language And .Net Framework to do this? What is the Benefits of Use VBA or Use .Net Framework? Which One Is Better To Learning And Focus?

  Read the article

• Is there a way to select nth column in a SELECT clause from a table/view

  - by Vishal Seth

  I've this GIGANTIC view with several hundred columns and I need to select 114th column something like: SELECT "144" FROM MyView; PS: Obviously, I don't know the name of the column. I just copied the results row into an Excel file, searched for a particular value that is in EJ column so I want to select all rows showing only nth column in my view to do my further debugging. Cheers!

  Read the article

• Download file using ajax and webservice

  - by megabyte

  Hi All There is this 3rd party webservice. One of the public webmethods available is a GetDocument() method. This method returns a Document object. The Document object has properties for File(byte[]), ContentType(string) ect. My Question : Can I subscribe to this service using javascript(mootools) + ajax + JSON, return the document object, in this case an excel document, and force the file download?

  Read the article

• Sql Server OLEDB provider error. The provider ran out of memory error.

  - by Serdal

  Sorry for my english :). I have a windows service. Service report some excel files weekly. But i got a"OLE DB provider 'SQLOLEDB' reported an error. The provider ran out of memory" Ole Db error. Service use SQl Server 8.00.194 and it link another SQL Server. I do not know why i receive this error. Thanks for help.

  Read the article

• Programatically upload XML file to SSRS server

  - by xt_20

  Hi all, How do I programatically upload an XSLT file to an SSRS server database? I would like exactly the same functionality as the 'Upload File', preferably using the 'rs' command. I have tried rs.CreateResource, but it doesn't seem to work for XML/XSLT files (though it works for Excel and image files) I understand that manipulating the SSRS db is not supported. Thanks

  Read the article

• How can I call different sprites images and properties of it from a file ?

  - by srikanth rongali

  My small game consists of a player and 10 targets. I have an excel sheet of information of target. It includes the target speed, target accuracy, target probability of hitting of the player. These factors change from target1 to target10. Each time target should appear on screen starting from target1 to target10. How can I call them in such a way?

  Read the article

• Crystal reports CSV incorrect generation

  - by yauhen

  When setting ExportFormatType.CharacterSeparatedValues crystal report generates every row of data prefixed with column names (Report Headers). Why it does this? How it could be fixed? Usually it is preferred to have single header. For excel export type - generated report looks ok (only single header for all rows). I am using crystal reports 11.5.3700.0. Visual studio 2008, .net 3.5 sp1

  Read the article

• How do you read a cell's value from an OpenOffice Calc .ods file with python?

  - by user329257

  I have been able to read an excel cell value with xlrd using column and row numbers as inputs. Now I need to access the same cell values in some spreadsheets that were saved in .ods format. So for example, how would I read the value stored in cell E10 from a .ods file from python?

  Read the article

< Previous Page | 153 154 155 156 157 158 159 160 161 162 163 164  | Next Page >