Search Results

Search found 4783 results on 192 pages for 'excel vba'.

Page 154/192 | < Previous Page | 150 151 152 153 154 155 156 157 158 159 160 161  | Next Page >

• reading app.config in Shared Add-In

  - by Sathish

  I have created a shared Add-in for Excel and want to use App.config for some of the settings. I have read somewhere that i cant use app.config for shared Add in(dll). Please let me know is there any other way to read this config file

  Read the article

• C# - Password Database

  - by user335932

  So I want to make a program that allows you to store and search for user names/passwords for online sites there signed up to. I know C# has some database options but I don't know much about it. I also heard that it can read/write excel files. Whats do you think is best for storing the data? ALSO do databases need to be stored online on a sever, or can they reside in the program files?

  Read the article

• Gridview "Freeze Pane" Solutions

  - by timeitquery

  I am looking for ways to implement scrolling in a gridview similar to freepanes in Excel. I need to keep the Header and the first columns static, and enable vertical and horizontal scrolling. I have seen commercial solutions, but I was looking for ways to make it work with the gridview.

  Read the article

• Best way to list Alphabetical(A-Z) using PHP

  - by PHP-Prabhu

  can any one please let me know, i need to print/list Alphabetical(A-Z) char to manage Excel cells. Is there any php function to list Alphabetic? I need result as A1 B1 C1 D1 ... ... ... OR A B C ... ...

  Read the article

• How can I build a CountIF function in SharePoint?

  - by Paul

  CountIF function in excel , How do I use the same function in sharepoint Calculated Field. I want count number of "GO" from Column 1 to Column 12 i.e. Col 1 "GO", Col 2 "GO", Col 3 "No GO", Col 4 "GO": GOs=3

  Read the article

• DataServiceCollection load from external source

  - by spdro

  I'm trying to load external data to my entyity. DataServiceCollection<products> products = new DataServiceCollection<products>(); var adapter = new OleDbDataAdapter("SELECT * FROM [products$]", "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=d:\\products.xlsx;Extended Properties=\"Excel 12.0;HDR=YES;\""); DataSet ds = new DataSet(); adapter.Fill(ds, "excell"); products.Load(????); Can anyone help ?

  Read the article

• how to provide list of sheets of file in combo box ?

  - by angel ansari

  Hi, I have to load excel file into sql server i use window application so i select filepath in textbox when click button using fileopendialogbox my problem is that i want ot provide list of sheets of file in combo box. so user can select appropriate sheet to upload. Because it may possible that there are many sheets in file and tool doesn’t know which one to upload.

  Read the article

• What is the current status on Microsoft ProClarity?

  - by Ali_Abadani

  I don't really know how to compose this question. My complay has been using Microsoft ProClarity for few years and we have a quite a few users using it publising books and doing ad-hoc analysis. With the new Microsoft BI solutions, it seems like they are completely going away from ProClarity and replacing the OLAP analysis with Excel. I understand the with SharePoint and integration with PerformancePoint and reporting services the dashboards and reports would be done in SharePoint but what about the analysis? Any ideas?

  Read the article

• Is there a programmatic way to determine whether the file is being used?

  - by AngryHacker

  Case and point: I need to open an Excel file via Interop and it would help a lot to avoid ugly COM errors if I knew that the file was in use. Other than trying to open the file and catching the exception, is there a programmatic way to determine whether the file is in use?

  Read the article

• Javascript Click/Drag and Select Table rows and columns

  - by Eric V

  Hi, I am wondering if anyone knows a java script library that would add a "select" type of functionality as seen in excel/google docs where you can click and select several different parts of a row and/or column. I am looking at adding this functionality to my web application. Does anyone know where of library's preferably in java script that will be able to add this. Thanks in advance

  Read the article

• Best tutorial to learn SSIS

  - by Nabin

  Hi, Which book is best to learn SSIS. Actually in my project we need to take onput from CVS file and after processing the data in SQL server 2008 we have export it back to excel file. ASP.NET is used as UI for this. Thanks, Nabin

  Read the article

• how to retain exact numbers that come from Access Database

  - by Shiny

  MY scenario is... I have 6,000 datas in Excel Sheet.. I try to import to Access Database.It enters the Database like this.. UNit Price 34512.00 Vat 4.00 BUt when i Retrieve to DataGridColumn it Shows vat Rate as 4(whole number).I accept zeros has no values..But I need that to be displayed in Grid as 4.0 . How to achieve this

  Read the article

• is there a way to designate the line token delimiter in Perl's file reader?

  - by Dr.Dredel

  I'm reading a text file via CGI in, in perl, and noticing that when the file is saved in mac's textEdit the line separator is recognized, but when I upload a CSV that is exported straight from excel, they are not. I'm guessing it's a \n vs. \r issue, but it got me thinking that I don't know how to specify what I would like the line terminator token to be, if I didn't want the one it's looking for by default.

  Read the article

• Encoding in SQL to CSV

  - by Z77

  When do I execute query COPY TO ... CSV, I create CSV file. BUt when open it column with names in excel that should be with national characters are not as it should be. So my question is, If it is possible within a sql query to change this encoding to utf8? Or something else? Because I want that new created CSV file to be as final product for user on web. I hope someone understood what I want:)

  Read the article

• how to write Linq2Sql statement to sort several column in cascading way?

  - by Richard77

  Hello, I've 3 columns that I'd like to sort in the Excel way, i.e. sorting the first column, and for each element sorted in the first column, I'll sort the second column, and so on. Let's say I first sort alphabeticaly Countries, then for each country, I sort alphabeticaly cities. How do I do it using Linq2Sql? Thanks for helping

  Read the article

• excelsheet query

  - by Goodwill

  Hi, dadasdf\sdasdasd\qazxbbjj\test.txt Above is the string in cell A1 in excelsheet,I want to extract the last word from that cell.i.e,I want only test.txt,How can I acchive that using excel function.If it is acchived by declaring any variable then also help me out.

  Read the article

• How do you test your app for Iñtërnâtiônàlizætiøn?

  - by Larry K

  How do you test your app for Iñtërnâtiônàlizætiøn compliance? I tell people to store the Unicode string Iñtërnâtiônàlizætiøn into each field and then see if it is displayed correctly on output. --- including output as a cell's content in Excel reports, in rtf format for docs, xml files, etc. What other tests should be done?

  Read the article

• Copy and paste RESULTS of a file search

  - by ray023

  In order for me to get the results of a file search in a readable format, I use the following command line in a command prompt: dir *.* /s > myResultList.txt I then open that list in Excel, use fixed width format to get rid of all the stuff I don't want and then I have my list. Seems like a lot to do for something so simple. Does anyone out there have any recommendations for something that would work better than this?

  Read the article

• how to handle redirect from http response in c# code ?

  - by dotnetcoder

  I have a http request call that return a url . If I run this url in IE it returns a page that redirects to a another page and downloads the excel file. How can I abstract this whole process in a c# Api tha will deal with http request + response + redirect + file_downlaod in a method and evetually return the file or the file stream. thanks for the help.

  Read the article

• SSIS with different table structures

  - by Grace

  I have a flat file source from Excel that has a structure like this: **People** Day1 Day2 Day3 Day4 Person1 someValue ... Person2 Person3 And i would like the package to put this information in a database with standard columns 'Person', 'Day', 'Value'. Does anybody know how to do this - at the moment because the days are going along the top, the package is assuming these are seperate data columns when they are not really and the mapping is not working.

  Read the article

• Where can I write a temp file from ASP.NET?

  - by ProfK

  I have an 'access denied' problem on an ASP.NET web application, where the user uploads an Excel file and I try and write it to a folder. I don't have access to the host except FTP, so I can't set permissions. I thought that ASP.NET would be able to write to a folder that is under the web app root, but it isn't so. Is there anywhere I can write the file to that doesn't require me to set permissions?

  Read the article

• How to log user activity with time spent and application name using c#.net 2.0?

  - by user342777

  hi, I am creating one desktop application in which I want to track user activity on the system like opened Microsoft Excel with file name and worked for ... much of time on that.. I want to create on xml file to maintain that log. Please provide me help on that.

  Read the article

• How can I record who borrowed what for our office library?

  - by lrussell

  I am looking for suggestions for a very simple book borrowing system for our office library. For example, should we use an Excel spreadsheet, some email based system, build something ourselves, or is there a web application for this? It just needs to record the title and name of the borrower at a minimum.

  Read the article

• How can I save large amounts of data in C#?

  - by Adam

  I'm writing a program in C# that will save lots of data points and then later make a graph. What is the best way to save these points? Can I just use a really long array or should I use a text file or excel file or something like that?

  Read the article

• IE Kills Session After Exporting CSV [CakePHP]

  - by OneBlueMidnight

  i have a web application that export CSV and i logged in as admin but what happened during the exportation the IE opens a new tab and export the CSV but what happens next when you click any of the link on the web app you will automatically logout! This only happen on IE. here is the header i used: header("Content-type:application/vnd.ms-excel"); header("Content-disposition:attachment;filename=".$this->filename); I am using cakephp 1.3.x.x TIA :D

  Read the article

< Previous Page | 150 151 152 153 154 155 156 157 158 159 160 161  | Next Page >