Re: iterating through xml created from a spreadsheet - C# Discussion Boards

Re: pdf text manipulation

29-Sep-04 6:01

If you have questions specific to a particular product, then you need to ask on it's respective site. SourceForge has forums for each projects, so go to the iTextSharp project page and click on "Forums".

If that doesn't do what you need it to, there is another article on this site I just read the other day that may: A PDF Forms Parser[^]. There may be others as well, but you just need to search.

This posting is provided "AS IS" with no warranties, and confers no rights.

Software Design Engineer
Developer Division Sustained Engineering
Microsoft

[My Articles]

Jon G29-Sep-04 6:12

Jon G

29-Sep-04 6:12

iTextSharp does not provide an option to EDIT an existing pdf file.

Here is a quote from their tutorial:

You can't 'parse' an existing PDF file using iText, you can only 'read' it page per page.
What does this mean?
The pdf format is just a canvas where text and graphics are placed without any structure information. As such there aren't any 'iText-objects' in a PDF file. In each page there will probably be a number of 'Strings', but you can't reconstruct a phrase or a paragraph using these strings. There are probably a number of lines drawn, but you can't retrieve a Table-object based on these lines. In short: parsing the content of a PDF-file is NOT POSSIBLE with iText. Post your question on the newsgroup news://comp.text.pdf and maybe you will get some answers from people that have built tools that can parse PDF and extract some of its contents, but don't expect tools that will perform a bullet-proof conversion to structured text.

Also,

What iText DOES provide is the possibility to READ a PDF document and copy an entire page of this file into the PDF file you are constructing from scratch. This can be useful if you want to create a new document based on (an) existing document(s). You can add a Watermark, pagenumbers,...

You may want to check out http://itextsharp.sourceforge.net/tutorial/ch01.html[^]

Jon G
www.Gizmocoder.com

E-Commerce

The_Soul_Of_Rock28-Sep-04 17:29

The_Soul_Of_Rock

28-Sep-04 17:29

please show me how to do an ecommerce page.
Thank in advance.

Thanks
Rock Throught The Night

Re: E-Commerce

Werdna29-Sep-04 2:47

Edit excel text box using C#

29-Sep-04 2:47

There are several starter kits provided at asp.net:
http://www.asp.net/Default.aspx?tabindex=8&tabid=47[^]

One of them is commerce started kit. It includes all the source code.

manishoz28-Sep-04 14:40

manishoz

28-Sep-04 14:40

Hi,

I would like to edit a Excel TextBox using C#. I have done the selection using the following code:
((Excel.Shape)xa.ActiveWorkbook.ActiveSheet).Select("txtViews");

Next I want to edit the text in the TextBox. How do I do that? Any help would be highly appreciated.

Thanks,
Manish

iterating through xml created from a spreadsheet

wend28-Sep-04 12:51

wend

28-Sep-04 12:51

I'm trying to pick out individual cells in an xml document that has been created from an excel spreadsheet. The problem is that when a cell value is missing in the spreadsheet xml does not add a null value node to take the place of this, thus putting the xml out of synch - that is, what should be the 5th node in a row is now the 4th.

Does anybody know how to get around this? The only thing I can see extra in the xml is a new attribute ss:Index="5" for the cell after the one that has been missed.

wend

Re: iterating through xml created from a spreadsheet

Heath Stewart28-Sep-04 13:11

Re: Outlook sync component?

28-Sep-04 13:11

Use the attribute, then. Since you obviously already know the number of cells that should exist, you can author your loop so that if the ss:Index qualified attribute (don't forget about the XmlNamespaceManager) does not equal the current index in your loop, use continue (or just don't execute code a la your condition).

If you feel this is problematic, I suggest posting to the appropriate Office newsgroups on news://msnews.microsoft.com. Microsoft developers keep an eye on those and a discussion may already exist about that problem since I doubt it's uncommon.

This posting is provided "AS IS" with no warranties, and confers no rights.

Software Design Engineer
Developer Division Sustained Engineering
Microsoft

[My Articles]

Outlook sync component?

cmkWildsky28-Sep-04 11:53

cmkWildsky

28-Sep-04 11:53

Anyone recommend a good component to sync a sql database to Outlook's contacts/tasks/events? Intellisync looks great, but $50K(!) is a bit steep.

Thanks!

Chris

Heath Stewart28-Sep-04 13:12

C# COM object to TLB generation problem

28-Sep-04 13:12

This forum is for questions regarding C#. You might try and lounge.

This posting is provided "AS IS" with no warranties, and confers no rights.

Software Design Engineer
Developer Division Sustained Engineering
Microsoft

[My Articles]

Werdna28-Sep-04 10:35

28-Sep-04 10:35

I'm trying to access C# object as COM object in C++ and I generate TLB file and use
#import in C++, but I'm having a bit of problems with return types.

For example if have method:
string GetValue()

the generated interface (*.tlh file) gets translated to:
virtual HRESULT __stdcall GetValue (/*[out,retval]*/ BSTR * pRetVal ) = 0;

the return argument always gets put as last parameter.
All the example I've seen (in books or MSDN) do not do that. They always return whatever is returned.
Is there maybe some attribute I have to apply? I'm using VS2005, so maybe it's new behaviour there?
Thanks.

Heath Stewart28-Sep-04 15:41

28-Sep-04 15:41

This is the documented and expected behavior. All COM methods (and, by extension, properties) are supposed to return HRESULTs (as yours does), and what COM clients like VB and .NET via COM interop see is return values (although in .NET you can attribute your methods with PreserveSigAttribute - among other ways - to make sure an HRESULT is returned as an Int32 since the return result code might be important and may not be an error (like S_FALSE).

I recomend that you read Creating a CCW for COM enabled non .NET applications[^] here on CodeProject, as well as Exposing .NET Framework Components to COM[^]. Make sure that you hard-code GUIDs with the GuidAttribute and never change published interfaces (i.e., interfaces you've released unto the world). Always derive new ones. Also never use auto-generated class interfaces. Define your interfaces explicitly and implement your class interface as the first interface in your implementation list.

Also, what examples are you looking at? I've read about every article and API doc in MSDN and COM methods are all return HRESULTs or SCODEs (legacy) - it's part of the COM spec to do so. VB (pre-.NET) interprets [retval]s as return values, just like tlbimp.exe and VS.NET do when importing a typelib. Other late-bound clients like Windows Script (VBScript, JScript) do so as well.

This posting is provided "AS IS" with no warranties, and confers no rights.

Software Design Engineer
Developer Division Sustained Engineering
Microsoft

[My Articles]

Werdna28-Sep-04 16:00

28-Sep-04 16:00

Thanks for response. As usual Heath you provided excelent response.
I saw in MSDN example (COM Interop Part 2: C# Server Tutorial) at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/csref/html/vcwlkCOMInteropPart2CServerTutorial.asp?frame=true[^]
where they have public int PrintHi(string name) method and call it with only one parameter (string) and use return int value.

Heath Stewart28-Sep-04 18:34

28-Sep-04 18:34

You're actually supposed to use the PreserveSigAttribute when you do this. Some times the samples are incorrect. Try compiling the following:

using System;
using System.Runtime.InteropServices;
 
[assembly: ComVisible(true)]
[assembly: Guid("519a4822-f224-47fa-bdc7-8037829365dc")]
 
[InterfaceType(ComInterfaceType.InterfaceIsDual)]
[Guid("f9b77b61-b4f0-4be4-9c53-ded9592e90c6")]
public interface ITest
{
  [DispId(0)]
  int Foo(string value);
}
 
[ClassInterface(ClassInterfaceType.None)]
[Guid("ae5e53c8-54d6-4667-9396-582f5c8611bf")]
public class Test
{
  public int Foo(string value)
  {
    return value.Length;
  }
}

Compile using:

csc.exe /t:library test.cs

Next, register the library and generate a typelib:

regasm.exe /tlb test.dll

Finally, view the typelib:

oleview.exe test.tlb

You'll see the following:

// Generated .IDL file (by the OLE/COM Object Viewer)
// 
// typelib filename: test.tlb
 
[
  uuid(519A4822-F224-47FA-BDC7-8037829365DC),
  version(1.0),
  custom(90883F05-3D28-11D2-8F17-00A0C9A6186D, Test, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null)
 
]
library Test
{
    // TLib :     // TLib : mscorlib.dll : {BED7F4EA-1A96-11D2-8F08-00A0C9A6186D}
    importlib("mscorlib.tlb");
    // TLib : OLE Automation : {00020430-0000-0000-C000-000000000046}
    importlib("stdole2.tlb");
 
    // Forward declare all types defined in this typelib
    interface ITest;
 
    [
      odl,
      uuid(F9B77B61-B4F0-4BE4-9C53-DED9592E90C6),
      version(1.0),
      dual,
      oleautomation,
      custom(0F21F359-AB84-41E8-9A78-36D110E6D2F9, ITest)    
 
    ]
    interface ITest : IDispatch {
        [id(00000000), propget,
          custom(54FC8F55-38DE-4703-9C4E-250351302B1C, 1)]
        HRESULT Foo(
                        [in] BSTR value, 
                        [out, retval] long* pRetVal);
    };
 
    [
      uuid(AE5E53C8-54D6-4667-9396-582F5C8611BF),
      version(1.0),
      custom(0F21F359-AB84-41E8-9A78-36D110E6D2F9, Test)
    ]
    coclass Test {
        [default] interface _Object;
    };
};

If you used PreserveSigAttribute, then it would simply be HRESULT Foo(BSTR value).

This posting is provided "AS IS" with no warranties, and confers no rights.

Software Design Engineer
Developer Division Sustained Engineering
Microsoft

[My Articles]

Werdna29-Sep-04 4:33

29-Sep-04 4:33

Also, while we're on the subject.
How do strings returned from .net work?
If I have a method string getSomething()
I have to call it as: HRESULT getSomething(BSTR* result);

It seems I have to allocate the string for the result.
I'm doing:
CComBSTR result(20);
and call it:
getSomething(&result.m_str);

what happens if I return string longer than 20 characters? Does CLR allocate more chars?

I tried looking in MSDN, but I couldn't find any information. It seems all examples I can find only deal with ints or doubles.

Heath Stewart29-Sep-04 5:51

29-Sep-04 5:51

It's an [out, retval]. Most often, you don't allocate these as the caller. Merely declare a variable and pass the address of the variable. Also, if you read the documentation for the CComBSTR class, you'll see the following remarks:

Memory Leak Issues

Passing the address of an initialized CComBSTR to a function as an [out] parameter causes a memory leak.

In the example below, the string allocated to hold the string "Initialized" is leaked when the function OutString replaces the string.

CComBSTR bstrLeak(L"Initialized");
HRESULT hr = OutString(&bstrLeak);

To avoid the leak, call the Empty method on existing CComBSTR objects before passing the address as an [out] parameter.

Note that the same code would not cause a leak if the function's parameter was [in, out].

So, as you see - don't initialize it. You also don't need to mess with m_str. Since the CComBSTR contains only one member - m_str - passing the address of the CComBSTR instance is passing the address of the m_str (because of the way the class/struct is aligned).

This posting is provided "AS IS" with no warranties, and confers no rights.

Software Design Engineer
Developer Division Sustained Engineering
Microsoft

[My Articles]

Werdna29-Sep-04 6:17