This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes General Computing and the fly likes Excel related query-Need help Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

JavaRanch » Java Forums » Engineering » General Computing
Bookmark "Excel related query-Need help" Watch "Excel related query-Need help" New topic

Excel related query-Need help

sunita shaw
Ranch Hand

Joined: Apr 06, 2003
Posts: 45
In my Excel matrix

1.VLOOKUP("Project Planning",C3:H3,6,FALSE) returened a "#N/A" when there is no "Project Planning" found in that cell .But I would like to replace "#N/A" by zero..How can I do that
2.I enabled a macro on my worksheet but when I am trying to disable or delete just refuses to do so..How can i do it...

Plzz help
Chetan Parekh
Ranch Hand

Joined: Sep 16, 2004
Posts: 3640

Java people don�t play much with Microsoft Excel.

Better you try here.
[ March 07, 2006: Message edited by: Chetan Parekh ]

My blood is tested +ve for Java.
Ulf Dittmer

Joined: Mar 22, 2005
Posts: 42958
Java people don�t play much with Microsoft Excel.

I don't think that's a correct statement, but in any case - Excel questions fit into this forum.
Sameer Jamal
Ranch Hand

Joined: Feb 16, 2001
Posts: 1870
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link:
subject: Excel related query-Need help
It's not a secret anymore!