Search Results

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

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

• How to SELECT the last 10 rows of an SQL table which has no ID field?

  - by Edward Tanguay

  I have an MySQL table with 25000 rows. This is an imported CSV file so I want to look at the last ten rows to make sure it imported everything. However, since there is no ID column, I can't say: SELECT * FROM big_table ORDER BY id DESC What SQL statement would show me the last 10 rows of this table? The structure of the table is simply this: columns are: A, B, C, D, ..., AA, AB, AC, ... (like Excel) all fields are of type TEXT

  Read the article

• When writing a form submit to a file, strip line breaks and commas

  - by bccarlso

  I have a form with a textarea in it. I log the results to a text file on the server, but I would like to strip out any line breaks a user would put in the textarea, as well as any commas that would interfere with importing the comma-delimited log text file into Excel or something for later use. I think this has to do with regex, but I'm no expert and could use some help. Or maybe there is an easy PHP function that will do it?

  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

• Top 10 Graph Charting Tools

  - by Daniel

  When charting information what is the best tool to use? Of course we call know if excel, but is there something better then that? I know if things like Google Chart Tools: http://code.google.com/apis/charttools/ But want to know what the best tools out there are.

  Read the article

• What's the right tool for this job in Google Spreadsheets?

  - by Daniel Harvey

  Is it possible to nest simple programs within a Google doc spreadsheet, similar to how you would w/Basic in Excel? Or alternatively a simple = syntax using regex, if there is a way to do that in google docs? I want to take a list of multiple names(name1, name2, name3) in a single cell from across multiple identical sheets and transpose them to another sheet within the same spreadsheet, check for duplicates and ignore capitals, etc. Is there a way to do this?

  Read the article

• Should I use office open xml or rdlc reports?

  - by Si Keep

  I need to provide the facility for a user to download Word and Excel reports from my web site. I was intending to use the Office Open Xml SDK but have just stumbled across RDLC. My question is should I consider RDLC? Does it give me the same flexability that the Office Open Xml SDK does? What are the pro's and cons?

  Read the article

• convert table of input values into 2D array or struct?

  - by Henry

  What's the easiest way to convert a table of values (2D grid like Excel), into a 2D array or struct in ColdFusion? Thought of using dot in the name and eval them to become struct, but AFAIK name attribute of input field can only contains alpha numeric and underscore, and first char must be an alpha char.

  Read the article

• Command line CSV viewer?

  - by Benjamin Oakes

  Anyone know of a command-line CSV viewer for Linux/OS X? I'm thinking of something like less but that spaces out the columns in a more readable way. (I'd be fine with opening it with OpenOffice Calc or Excel, but that's way too overpowered for just looking at the data like I need to.) Having horizontal and vertical scrolling would be great.

  Read the article

• Is it possible to search in all the content of files uploaded to SharePoint Server?

  - by foxtrot

  Hi, there. I wish to made available a functionality that searches in all pages and content inside all the documents (word, excel, pdf, etc.) present in our SharePoint Server 2007 that all the users uploaded. Anyone could tell me if this is possible? Thanks in advance. Regards.

  Read the article

• How can i get the between cell addresses.

  - by Sathish

  I have a function which accepts fromRange and ToRange of an Excel cell. basically i want to read cell by cell values from the range. suppose if i pass E2 and E9 i want to read in a loop something like Range(E2).value, Range(E3).value and so on till E9 How can i get the between cell addresses. Please help

  Read the article

• OLE AUTOMATION WITH PHP or PHP-CLI ?

  - by asksuperuser

  I read here http://www.daniweb.com/code/snippet217293.html# it is possible. What should be activated in PHP.Ini or elsewhere to make this work ? Are there any examples with Excel ?

  Read the article

• I know my Before Tax Pay and my After Tax Pay, how can I work out how much I get taxed?

  - by Pete

  I've been entering some data into an Excel spreadsheet to work out my monthly earnings, etc. and was wondering how I can I find out how much I'm getting taxed? Say this is my current spreadsheet: Hours Worked 37.5 39.5 37.5 30 Hourly Rate $25 $25 $25 $25 Before Tax 937.50 987.50 937.50 750.00 After Tax 260.00 276.00 260.00 ??? How can I use this known data to work out my After Tax pay for the 4th column? :/

  Read the article

• JExcel doesn't copy Array formula

  - by Fletcher

  I open excel file by JExcel, modify some cells and save it. As result Array formulas({ ... } CTRL+SHIFT+ENTER) was broken. Does anybody know what to do? (FormulaException is rasing during copy)

  Read the article

• help with UnicodeEncodeError('ascii', u'Phase \u2013 II', 6, 7, 'ordinal not in range(128)')

  - by laspal

  Hi, having problem with UnicodeEncodeError('ascii', u'Phase \u2013 II', 6, 7, 'ordinal not in range(128)') Basically what I am doing here is reading the value from excel sheet and sheet contain address in this format Phase- II So wanted to know how to change` somestring = u'Phase \u2013 II' to str thanks `

  Read the article

• Recommended Offline Form Format

  - by Blithe

  Hi, I would like to ask for a recommendation on offline form format which user can bring around. Once done, they will upload the file to the server and data will be extracted from there. We are currently looking at Word and Excel 2003 since all users have it on their machine but it seems that using interops on server is something to avoid. Suggestions?

  Read the article

• How to do number formatting to 1 decimal point in SSRS?

  - by san

  Hi, I have a SSRS report with full of number fields. I would like to have that to be displayed as in one decimal. i tried to use F1. it gives me only one decimal points in html rendering, but in excel exported version it shows 2 decimal points. How can i have just one decimal point both ecxel and html rendering. Please comment. Thanks in advance San

  Read the article

• How to convert PDF to word using Acrobat SDK

  - by kkk

  My .Net application needs to convert PDF document to word format pro-grammatically. I evaluated several products and found acrobat x pro , which gives a save as option where we can save the document in word/excel format. I tried to use Acrobat SDK but couldn't find proper documentation from where to start. looked into their IAC sample but couldn't understand how to call the menu item and make it execute the save as option. Please help me if you have any idea regarding this.

  Read the article

• ruby request.query_string

  - by Small Wolf

  Hey ,Guys! I want to use the method request.query_string to send the key-value to the controller,how can i use in the sentences; =link_to 'excel' , reports_excel_path(:format => 'xls',:from => 'conversations') Thank you!

  Read the article

• Bulk Compare, Report, Update

  - by Tim Donaldon

  I need to import either csv or excel file into a dbase. The column headers will match but I will want to compare the file against the dbase using an ItemID field, list the rows to be affected and the differences, then allow an update to all the rows with the matching ID.

  Read the article

• What is the XML spec for importing into Microsoft Project?

  - by montek

  From our existing, internal tracking system I would like to create an XML export that I can then bring into Microsoft Project 2007 to further display and manipulation. I've been unable to find a straightforward explanation of how the XML should look for this kind of import. I want to be able to create dependencies, assign resources, etc. The Excel/CSV imports don't appear to offer all these capabilities so I think XML is the better way...if I could just get a spec for it.

  Read the article

• Btrieve Date Integer

  - by nmiranda

  Hi everyone, this is my question: I'm migrating data from a Btrieve file (.dat) through Pervasive Control Center and there is field type which is defined as integer but is a date and for example the date '31/12/2009' (seen in the legacy system) is view it as the number 733772 when I export it. The legacy system shows the date correctly but I can't export it in the same format or at least I can't convert it. Does anybody know how to convert this number through Excel or something?

  Read the article

• Difference between 2 NSDates, excluding Weekends?

  - by Burnsoft Ltd

  For those familiar with Excel, I'm trying to use a similiar NETWORKDAYS function within Cocoa. Can anyone help with the type of info I'll need to construct an NSDate catagory that can give me only the working days betweek two dates? many thanks Nik

  Read the article

• C# language: How to freeze listview control in windows form?

  - by aYa

  hello, i need to freeze certain columns in listview so when the user scrolls horizontally the frozen columns will not be affected (like in excel) but there is no frozen(bool) property like that in datagrid. Can this be done in listview control? Thanks

  Read the article

• merging and manupulating files in matlab

  - by Paul

  Is there a way to run a loop through a folder and process like 30 files for a month and give the average,max of each columns and write in one excel sheet or so?? I have 30 files of size [43200 x 30] I ran a different matlab scrip to generate them so the names are easy File_2010_04_01.xls , File_2010_04_02.xls ..... and so on I cannot merge them as each are 20mbs and matlab would crash. Any ideas? Thanks

  Read the article

• Lightweight Java reporting engine

  - by tuler

  I'm looking for a lightweight java reporting engine to be embedded in an applet application. My first option was Jasper Reports, but the jar is over 2Mb, a little too heavy (and too bloated) for my needs. I don't know if there is modular jasper distribution, with funcionalities split in several jars (like html rendering, pdf, excel, compilation, runtime, etc). I need to preview the report using Swing and print it. PDF export is a plus.

  Read the article

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