|
I've searched and found examples on how to write to an excel file, but I'm having trouble figuring out how to code to read all lines of a txt (say 10000 lines) and then write a new row every time a delineator is found which is on a line all by itself. The columns are predefined.
My code is as follows, but is not complete, any help would any appreciated. Thank you.
StreamReader parseFile = new StreamReader(@"C:\temp\output.txt");
string fileRead = parseFile.ReadToEnd();
string line;
string year = DateTime.Now.Year.ToString();
while ((line = parseFile.ReadLine()) != null)
{
int linenumber = 0;
if (line.EndsWith("(null)") != true)
{
linenumber = linenumber + 1;
Excel.Range range = oSheet.get_Range("A" + linenumber, );
range.Value2 = line;
}
}
parseFile.Close();
|
|
|
|
|
This[^] CP Archive Item may help.
------------------------------------
I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave
CCC League Table Link
CCC Link[ ^]
|
|
|
|
|
Hello,
I have a winform project (c#) with a media player embedded inside.
When I start playing a song, I can see the equalizer inside the WMP window.
I want to duplicate this window so I will see the same window twice (right side and left side of my winform window).
Can I do that?
I thought about adding another WMP which will play the same songs but I'm afraid that it won't play at the same time.
Thanks
|
|
|
|
|
I am trying to customize the IME UI windows in a C# application which custom draws all of its controls. The main form can get the WM_IME_SETCONTEXT, and a couple of other messages, but I don't see how to trigger the IME to tell my application when to open any of the IME windows (composition, reading, or candidate). Are there any C# samples that I can look at which do the same? Or any C++ for that matter?
Or does anyone have any idea what I might need to do to trigger the IME to request these windows be opened? I set the IME to use PRC Chinese and I see the WM_IME_COMPOSITION message. In response to that message, ImmGetCompositionString() returns zero length. Then I see no additional messages.
I am responding to WM_IME_SETCONTEXT by clearing the lPARAM and then passing it to the DefWinProc, allowing the latter to set the results.
Any help would be appreciated.
Update: It seems that the problem is the IME/IMM is not aware that it should be processing the WM_KEYDOWN, and I am getting WM_CHAR messages instead of WM_IME... messages for composition and more.
modified on Thursday, January 13, 2011 9:58 PM
|
|
|
|
|
I am working on implimenting a 3rd party API written in C++. The API pulls an image from a scanner. I have tried a few different ways of of working with the image struct but every attempt causes memory crashes with P/Invoke. Any suggestions would be appreciated.
Here is the C++ code and sample that comes with the device.
typedef struct {
int width;
int height;
int info;
unsigned char* pbuf;
} MY_IMAGE;
MY_IMAGE img1,img2;
img1.width = 864;
img1.height = 3000;
img1.info = 8;
img1.pbuf = (UCHAR *)new UCHAR[2*nWidth*nHeight];
img2.width = 864;
img2.height = 3000;
img2.info = 8;
img2.pbuf = (UCHAR *)new UCHAR[2*nWidth*nHeight];
ret=WScanSelectBuf(&img1, &img2,0);
---------------------------------------------------------------------
[StructLayout(LayoutKind.Explicit)]
public struct MY_IMAGE
{
[FieldOffset(0)]
public int width;
[FieldOffset(4)]
public int height;
[FieldOffset(8)]
public int info;
[FieldOffset(12), MarshalAs(UnmanagedType.SysUInt)]
public IntPtr pbuf;
}
[DllImport("scandll.dll")]
private extern static int WT_ScanSelectBuf(ref MY_IMAGE image_down, ref MY_IMAGE image_up, int select);
public static int ScanSelectBuf(ref MY_IMAGE image_down, ref MY_IMAGE image_up, int select)
{
return WScanSelectBuf(ref image_down, ref image_up, select);
}
ImageInfo img1 = new ImageInfo();
ImageInfo img2 = new ImageInfo();
int nWidth = 864;
int nHeight = 1000;
img1.width = nWidth;
img1.height = nHeight;
img1.info = 8;
img2.width = nWidth;
img2.height = nHeight;
img2.info = 8;
ret = ScanSelectBuf(ref img1,ref img2, 0);
|
|
|
|
|
At a first glance, this is what I would do:
Declare MY_IMAGE as a class, not as a struct; use LayoutKind.Sequential instead of Explicit; remove FieldOffset attributes; do not use MarshalAs for pbuf field (pbuf should be an IntPtr); import the function without the ref keywords.
To assign the value to pbuf field you need to have the bytes in a byte[] array. Then you just have to set pbuf to the address of that array, using Marshal.UnsafeAddrOfPinnedArrayElement method.
|
|
|
|
|
Hi Erik, thanks for the suggestion. Below are the changes I have made. However, I am still receiving memory errors.
[StructLayout(LayoutKind.Sequential)]
public class MY_IMAGE
{
public int width;
public int height;
public int info;
public IntPtr pbuf;
}
[DllImport("scandll.dll")]
private extern static int WScanSelectBuf(MY_IMAGE image_down, MY_IMAGE image_up, int select);
public static int ScanSelectBuf(ref MY_IMAGE image_down, ref MY_IMAGE image_up, int select)
{
return WScanSelectBuf(image_down, image_up, select);
}
And also
public static int ScanSelectBuf(MY_IMAGE image_down, MY_IMAGE image_up, int select)
{
return WScanSelectBuf(image_down, image_up, select);
}
The API does not provide any other way to fill the MY_IMAGE struct other than calling:
private extern static int WScanSelectBuf(MY_IMAGE image_down, MY_IMAGE image_up, int select);
So, I do not have acces to fill the buffer with a byte[]. This should be happening from caling the method.
Erik - Is there anything I missed? If so, do you have an example?
Luc - Would you be able to provide an example of what you were referring to?
|
|
|
|
|
econner wrote: So, I do not have acces to fill the buffer with a byte[]. This should be happening from caling the method.
I understand that the buffers are filled by WScanSelectBuf, am I right? If so, maybe you have to allocate these buffers before calling the function, I mean, create the instances of byte[] array, pin them with GCHandle and assing the address to the pbuf field of the MY_IMAGE objects. Can you give us a link to the documentation for the C++ library you are using? I would like to know what the three parameters are for, and what the WScanSelectBuf function is supposed to do. I think we might be able to give you a better help with a little more information.
|
|
|
|
|
Correct, on the buffer.
Here is an excert from the docs:
//Scan to buffer.
int WScanSelectBuf(void* image_down, void* image_up ,int select)
(param)
image_down [out] structure for forward direction scan.
image_up [in] NULL (reserved)
select
[in] 0 : forward direction & single scan (use image_down)
1 : backward direction & single scan (use image_up)
2 : both direction & single scan (use image_down & image_up)
3 : forward direction & dual scan (use image_down)
4 : backward direction& dual scan (use image_up)
5: both direction & dual scan (use image_down& image_up)
Return value - Success 0, Fail > 0
|
|
|
|
|
Have you allocated and pinned the byte[] arrays before calling the function?
|
|
|
|
|
No, I have not. From the C++ example, they show setting the pbuf size, but with using IntPtr I was not sure how to accomplish the same thing.
|
|
|
|
|
Create a byte[] array with the same size you need in C++ for UCHAR. Use GCHandle class to pin this array, so the GC will not reallocate it in case of a garbage collection, and set its address to the pbuf field. Have a look at the documentation of GCHandle class.
|
|
|
|
|
I have modified the code as per my understanding of GCHandle. I am still getting memory errors. I believe it has something to do with the IntPtr of the pbuf in the MY_IMAGE struct.
Here is my code so far:
[StructLayout(LayoutKind.Sequential)]
public class MY_IMAGE
{
public int width;
public int height;
public int info;
public IntPtr pbuf;
}
[DllImport("scandll.dll")]
private extern static int WScanSelectBuf(IntPtr image_down, IntPtr image_up, int select);
public static int ScanSelectBuf(MY_IMAGE image_down, MY_IMAGE image_up, int select)
{
GCHandle image_downHandle = GCHandle.Alloc(image_down, GCHandleType.Pinned);
GCHandle image_upHandle = GCHandle.Alloc(image_up, GCHandleType.Pinned);
int ret = WScanSelectBuf(image_downHandle.AddrOfPinnedObject(),
image_upHandle.AddrOfPinnedObject(), select);
image_downHandle.Free();
image_upHandle.Free();
return ret;
}
MY_IMAGE img1 = new MY_IMAGE();
MY_IMAGE img2 = new MY_IMAGE();
int nWidth = 864;
int nHeight = 1000;
img1.width = nWidth;
img1.height = nHeight;
img1.info = 8;
img2.width = nWidth;
img2.height = nHeight;
img2.info = 8;
ret = ScanSelectBuf(img1, img2, 0);
Anything I am missing ???
|
|
|
|
|
Yes, you are pinning the MY_IMAGE objects, but that is not what you have to pin. When you call a function using P/Invoke, the CLR automatically pinnes in the managed heap the references you pass, so there is no need to explicitly pin them as you have done. However, the pbuf field of each MY_IMAGE class is an IntPtr, what means that it only contains the memory address of the buffer allocated to receive de image pixels. As it is only an address, the CLR will not pin these buffers automatically, and that is why the programmer has to pin them manually before using the P/Invoke call. In this case you have not even allocated the buffers, so the values of the pbuf fields of the MY_IMAGE objects you are passing to the unmanaged function are IntPtr.Zero, I mean, the default value for IntPtr.
This is what you have to do:
Before you call the WScanSelectBuf you have to create the two MY_IMAGE objects and allocate the byte[] arrays where that function will place the image pixel:
MY_IMAGE img1 = new MY_IMAGE();
MY_IMAGE img2 = new MY_IMAGE();
byte[] buffer1 = new byte[2*img1.width*img1.height];
byte[] buffer2 = new byte{2*img2.width*img2.height];
GCHandle bufferHandle1 = GCHandle.Alloc(buffer1, GCHandleType.Pinned);
GCHandle bufferHandle2 = GCHandle.Alloc(buffer2, GCHandleType.Pinned);
img1.pbuf = bufferHandle1.AddrOfPinnedObject();
img2.pbuf = bufferHandle2.AddrOfPinnedObject();
int ret = WScanSelectBuf(img1, img2, select);
bufferHandle1.Free();
bufferHandle2.Free();
Tell us if it works.
|
|
|
|
|
I modified the code as per above. The img1.pbuf and img2.pbuf are now showing an address. However, the native API funtion of WScanSelectBuf(img1, img2, select) is still crashing. I have tried passing in:
WScanSelectBuf(img1, img2, select) (MY_IMAGE)
WScanSelectBuf(ref img1, ref img2, select) (ref of MY_IMAGE)
WScanSelectBuf(img1, img2, select) (IntPtr)
and changed the code in the DLLImport and wrapper method without any success. Is there anything I am missing with Marshaling, etc?
I am coming to the conclusion that it could be an issue with the 3rd party's API libary and is doing something odd with the function. However, it does work in their C++ sample.
I have contacted the vendor and they are not familar with .NET. However, they are reviewing this thread and for any suggestions.
|
|
|
|
|
Ok, it's pretty weird... I am not sure what is going on here. The correct way to import MY_IMAGE type and the function is as I told you before, there is no need of marshaling for any field. You might try a little change, using Marshal.UnsafeAddrOfPinnedArrayElement instead of AddrOfPinnedObject method of GCHandle class, I mean, you first pin the buffers with GCHandle and then set the address in pbuf fields this way:
img1.pbuf = Marshal.UnsafeAddrOfPinnedArrayElement(buffer1, 0);
img2.pbuf = Marshal.UnsafeAddrOfPinnedArrayElement(buffer2, 0);
If it still does not work, you might try allocating the buffers directly in the global heap, with Marshal.AllocHGlobal (remember to free this memory when you don't need it any more), instead of creating them in the managed heap as we did before when instantiated the buffers with new byte[size]. If this works you should then copy the buffers allocated in the global heap to the managed heap with the method Marshal.Copy.
|
|
|
|
|
Ok, below are the changes I tried. However, I am receiving an error of: "Attempted to read or write protected memory. This is often an indication that other memory is corrupt."
[DllImport("scandll.dll")]
private extern static int WScanSelectBuf(MY_IMAGE image_down, MY_IMAGE image_up, int select);
public static int ScanSelectBuf(MY_IMAGE image_down, MY_IMAGE image_up, int select)
{
return WScanSelectBuf(image_down, image_up, select);
}
int nWidth = 100;
int nHeight = 200;
img1.width = nWidth;
img1.height = nHeight;
img1.info = 8;
img2.width = nWidth;
img2.height = nHeight;
img2.info = 8;
byte[] buffer1 = new byte[2 * img1.width * img1.height];
byte[] buffer2 = new byte[2 * img2.width * img2.height];
GCHandle bufferHandle1 = GCHandle.Alloc(buffer1, GCHandleType.Pinned);
GCHandle bufferHandle2 = GCHandle.Alloc(buffer2, GCHandleType.Pinned);
img1.pbuf = Marshal.UnsafeAddrOfPinnedArrayElement(buffer1, 0);
img2.pbuf = Marshal.UnsafeAddrOfPinnedArrayElement(buffer2, 0);
ret = ScanSelectBuf(img1, img2, 0);
bufferHandle1.Free();
bufferHandle2.Free();
|
|
|
|
|
Erik - Thanks for your help.
I have it working now. The reason it was failing after the last step was due to other settings that had to be set on the scanner. The vendor makes a single side and double side scanner. The sample in the documetation does not match the process. I dug around in the C++ sample and found other settings that I was able to specify before scanning the card.
|
|
|
|
|
One of the functions was not in the documentation and the sample I was using. I found the function when reviewing the header file and the C++ test app code.
|
|
|
|
|
Erik,
I wanted to thank you again for the assistance.
I was able to confirm that the code require the buffer and pinning/marshaling of the memory and it will not work correctly without the suggestions you provided.
I also wanted to let you know what compounded the testing issue with the error was due to incomplete documentation. After getting the process to work, I was able to change certain settings and was able to cause the process to fail. Basically, the image class has to define the height and width to the MAXIMUM allowed image that the scanner can accept. Then the buffer size is set to the max height * max width * single/double scanner mode. Once the scanner returns the image, it adjusts the height and buffer values to be what are read in from the scanner. If the image sizes are specified incorrectly/too small, the API will cause a memory error. For example, the image of the scanned area may be 4" but the scanner's read head is capable of scanning a wider area. So the image width has to be pre-set the maximum width of the read head and not the width of the item that is being scanned. BTW, these maximum values are not specified in the documentation or samples. I actually had to dig thru a C++ sample application and the header files to find these settings.
Thanks again.
|
|
|
|
|
You're welcome. I'm glad to know you finally solved it.
|
|
|
|
|
It is very fortunate the caller is responsible for the buffer, so you can have it all managed. You need to allocate a byte array of sufficient capacity, and pass its pointer (an IntPtr in .NET); you won't need any Marshal attributes, not even any unsafe stuff. Look for the GCHandle class, and read how I pass arrays in this article[^]. Don't forget to free the GCHandle once you don't need it any more (which could be well after the return of the first native function, if it happens to keep the pointer around).
Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.
|
|
|
|
|
This was an example of another library that I was using as reference. It was confusing so I removed it since it is not the code I am having issues with.
modified on Thursday, January 13, 2011 8:48 PM
|
|
|
|
|
Not sure what your question is here.
I would comment on the code like this:
1. it does not seem complete. Where is the buffer allocated?
2. I guess, but am not sure, the Marshal attributes used are sufficient to get the buffer pinned for as long as the native method lasts, but no longer.
3. Constructing an image from native data is fine, however it requires the underlying data to remain available as long as the image object lives (see MSDN doc), and that is not very easy to implement correctly. It sure does not show in your code.
Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.
|
|
|
|
|
Ok, I have looked a little more at your article. The Marshalling and pinning of the memory is something that I dont work with much. However, it does make sense with the type of memory error that I am receiving.
So, from the original code I posted, how would you maybe suggest I change the stuct, DllImport, and calling methods to be in line with the Marshalling, pinning, and GCHandle? Would the parameter types change?
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
