629 Topics

Member Avatar for
Member Avatar for man3388

Hi, I need to compare following xml file USING C#: [CODE] <Issue> <IpIssueId>790</IpIssueId> <IpIssueGuid>11</IpIssueGuid> <IssueName>Summary</IssueName> <RuleQuery>Rule1</RuleQuery> <Classification>R</Classification> <IssueError>Summary</IssueError> <Severity>100</Severity> <IssueFormat>Total domains: [[DomainCount]] </Issue> [/CODE] with excel file like: IssueName Type Summary Risk(R) bb Health(H) I need to verify whether "type" column of excel matches with "classification" tag of xml file.

0
82
Member Avatar for D4Stone

I want to buy MS Office 2007 or 2010 Professional and I can find it on Ebay at an average price of $175 US. I am wondering if there is some reason I am not aware of to not buy any of these programs. What do I need to know …

Member Avatar for ksharp25
0
816
Member Avatar for tordolsen

Hi everyone! Im really stuggeling with excel. I do know how to import txt-files from web into excel, but when i do, the charset is wrong. So the Norwegian letters ÆØÅ is now wierd symbols (Ã¥Ã). This is not the case if im importing the text-file from a local folder. …

Member Avatar for slurpee55
0
105
Member Avatar for Sargasso

I am currently trying to take two columns from a *.csv file... log10 transform them, and then plot them up on a graph. The graph is not the issue, I just need to edit those two columns and plot them. The file does have a header row, there are 8 …

Member Avatar for Beat_Slayer
0
125
Member Avatar for andrewktmeikle

Hi team, I've written a windows program and it works nicely but its really slow when it retrieves the data from the server. Program Overview: The program allows users to search through a database and add contacts if they want. Some of the fields on the forms fill up depending …

Member Avatar for maj3091
0
130
Member Avatar for madhub2v

Hello Friends. I want any resources or Ebooks on Couputer Basics in questions and ans format(multiple choice questions). these are for testing the knowledge of students on Computer h/w,S/W , DBMS, computer N/W ,and network security. thanks.

0
94
Member Avatar for leverin4

Is it possible to check which version of Excel a user's computer will open while in a VB6 application? Some users will be using Excel 2003 and some will be using Excel 2007 and, in theory, a single command button will open one of two excel sheets based on which …

Member Avatar for AndreRet
0
512
Member Avatar for D4Stone

Is it safe to purchase MS Office 2007 or 2010 on Ebay. Why can I buy it so much cheaper then the regular retail price? Is it legal?

Member Avatar for caperjack
0
249
Member Avatar for forumite

Training management system: Hi, I want to build a webpage in a plain HTML, JavaScript, CSS. In this webpage, I want to build a TRAINING MANAGEMENT SYSTEM. Requirements: 1. A form which should take the trainee's unique id and process it. If the entered trainee ID matches with any of …

Member Avatar for Henzard
0
225
Member Avatar for ronparker

Hello all, I recently made a mysql database using python and imported an excel file into the database. However, I am having some issues with some of the python. Using the following code, I have selected 11 numbers from a table in the database. # c.execute('SELECT REF_PNL FROM actual_data_table WHERE …

Member Avatar for vegaseat
0
971
Member Avatar for skyyforever

Hello, I have a problem opening Excel file which I have created using a xslt. Actually, I had a xml file which I transformed to an excel file and saved. I don’t know how to open it. Everything I have tried, didn’t work. Please, if someone knows the answer...

0
81
Member Avatar for dinkpwns

Hello everyone, I currently have an application that reads in an entire excel file then iterates through the records from the file and queries our database for a match. If a match is found the record is ignored if a match is not found the record gets added to the …

Member Avatar for dinkpwns
0
163
Member Avatar for Tweed

I am using Excel interop in my VB.NET program. My problem is that I can't seem to figure out how to write to Excel *and* define the Range using numbers. Alright, so I have objects being created depending on the file that the user opens. So there could be 100 …

Member Avatar for crapulency
0
325
Member Avatar for jon.kiparsky

Anyone played with the jxl API before? It's a tool for read/write access to Excel spreadsheets - a little bit dodgy, but it works. I wrote a piece of code for my brother using this a few months ago, and now he's starting to see a warning message, which is …

0
157
Member Avatar for coder05

hi there, i am new user of C++. i have to write a code for my final year thesis work though my subject is naval architecture. I did my coding perfectly. But i need to take the result in excel file. the problem is ,using outfile command , the whole …

Member Avatar for coder05
0
79
Member Avatar for judithSampathwa

Hi there, I have a question regarding excel in C#. I have a datagridview and in that I have a datagridview cell button to open an excel file and make it visible, and another to upload to save the file to a folder in a project folder, I add the …

0
77
Member Avatar for mguttman

I am trying to implement an application in which a Perl script uses Win32::OLE to populate a spreadsheet from a database and present it to the user. The user is then free to modify the spreadsheet [I]manually[/I]. The modified data is then required to update the database. We would prefer …

Member Avatar for mguttman
0
333
Member Avatar for judithSampathwa

Hi, I have a question relating to excel sheets in C#. I have a button in a datagridview in C#, how can I open an excel sheet when I click on the button. And then when the excel sheet opens I need to edit it, so how can I open …

Member Avatar for nick.crane
0
93
Member Avatar for andreas.cyp

Hey guys, I have 200 documents in similar structure and I want to extract data to excel file. What is the easiest way? Thanks

0
84
Member Avatar for G_Waddell

Hi all, I'm writing an application that imports and tidy up address data into a cleaned, deduped excel workbook ordered in rows with each column as an address field. One of the issues I've ran into is that we sometimes get a workbook where the multiple address fields are held …

Member Avatar for Baldur Levesque
0
251
Member Avatar for watergeek

I am using VB.net 2008 express edition I have figured out how to use some of the code snippets for the open xml sdk to create a drop down list of all the sheets in an excel file. I can also use the code snippet to get the value of …

Member Avatar for David Sanchez
0
1K
Member Avatar for sdmcnitt

I have a .NET winforms app that automates Excel and checks for a worksheet password. The requirements are to be able to detect 1) that the protection is turned off 2) that the password is removed (protected but there is no password) 3) that the password matches the correct password …

Member Avatar for nancyli148541
0
758
Member Avatar for Techwriter10

I read a blog post this morning on the Mini-Microsoft blog called [URL="http://minimsft.blogspot.com/2009/07/microsoft-has-turned-corner.html"]Microsoft Has Turned the Corner[/URL] and it got me wondering if they really have, or if it was merely wishful thinking on the part of the author. Then I saw that Microsoft had released [URL="http://www.microsoft.com/office/2010/"]Office 2010 videos[/URL] and …

Member Avatar for Tech_ww
0
675
Member Avatar for Glass_Joe

The world’s leading productivity suite is coming to a Mac near you late October and it will surprisingly save you an arm or a leg. Three editions will be available upon its venture onto store shelves: Mac Home and Business, Mac Home and Student, and Mac Academic 2011. [ATTACH]16318[/ATTACH]Microsoft Office …

0
209
Member Avatar for kaede1888

Recently I have some PDF files need to transfer to word for use in my office 2008. I firstly tried to copy and paste but the contents are messed up using Adobe Reader. I could not upload it to SNIP or other online websites because they are my company’s confidential …

Member Avatar for macgurl70
0
276
Member Avatar for gishi

hi! does anyone know how to convert excel file (xls and xlsx)(or even just xls) into csv preferably using xlrd and csv modules. i need to convert a specific excel sheet to csv. i need to create a csv file instead of using comma but semicolon. i am still not …

Member Avatar for gishi
0
619
Member Avatar for iamthwee

Here is a free excel to tab file convertor. Feel free to use for whatever purpose you want. There is no need for excel to be installed on the host pc. Assumes the user is on a windows platform. Extract all three files into one folder and run the main …

Member Avatar for iamthwee
0
443
Member Avatar for andrewktmeikle

Hey people, first all let me apologise if this in the wrong section I couldnt find a seciton for office or just excel. So i figured windows software was my second safest bet, he hopes lol. I'm having a problem with excel. I'm trying to write a function that will …

Member Avatar for andrewktmeikle
0
168
Member Avatar for AlanWilhelm

Hello, I put together a small tutorial that I wanted to share. I found only scattered information on this and put a more complete tutorial together with code and comments. [URL="http://blog.ajwilhelm.net/archives/7"]Parsing Excel files with Python[/URL]

1
86
Member Avatar for TiZo

Hi all, Can someone please help... I have a small youth football web site and would like to display the league table on a web page. What is the best way to display this information, so that it is not to manual when i come to update the results weekly. …

Member Avatar for TiZo
0
196

The End.