Free Excel to Vcf v1.0 is used to convert contact details in Excel (XLSX) files to Vcard(.vcf) v2.1
How to use:
1. Please make sure the Excel file is containing only the valid Column listed in the sample file
2. Before selecting the Excel file please set the row where the column names are present and contact details are present. ( I know the program flow is wrong , it will be corrected in next version).
3. Select the appropriate Excel file, the data present inside the excel is read and displayed in the application if its not reading correctly please tweak the row numbers and the column names appropriately till the required data is properly read inside the tool.
4. Finally click on the create Vcf file , select the required folder. Vcf file will be created.
a) Vcf file name is given accordingly "LAST NAME" "FIRST NAME".vcf
b) Individual Vcf is created for individual contacts.
This is in early stages of development for any bug report please post a comment in my blog.
This is tested on Windows 7 with Office 2010
Download
How to use:
1. Please make sure the Excel file is containing only the valid Column listed in the sample file
2. Before selecting the Excel file please set the row where the column names are present and contact details are present. ( I know the program flow is wrong , it will be corrected in next version).
3. Select the appropriate Excel file, the data present inside the excel is read and displayed in the application if its not reading correctly please tweak the row numbers and the column names appropriately till the required data is properly read inside the tool.
4. Finally click on the create Vcf file , select the required folder. Vcf file will be created.
a) Vcf file name is given accordingly "LAST NAME" "FIRST NAME".vcf
b) Individual Vcf is created for individual contacts.
This is in early stages of development for any bug report please post a comment in my blog.
This is tested on Windows 7 with Office 2010
Download
7 comments:
I have tried several times and get this message every time. please help.
************** Exception Text **************
System.Runtime.InteropServices.COMException (0x800A03EC): Exception from HRESULT: 0x800A03EC
at System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Int32[] aWrapperTypes, MessageData& msgData)
at Microsoft.Office.Interop.Excel.Range.get__Default(Object RowIndex, Object ColumnIndex)
at Excel_to_Vcf.Form1.Btn2_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5466 (Win7SP1GDR.050727-5400)
CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
Excel to Vcf
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Users/rtindle/AppData/Local/Temp/wz21a3/Free%20Excel%20to%20Vcf%20v1.0.exe
----------------------------------------
Microsoft.VisualBasic
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.5420 (Win7SP1.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualBasic/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualBasic.dll
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5467 (Win7SP1GDR.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5468 (Win7SP1GDR.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5467 (Win7SP1GDR.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Runtime.Remoting
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Runtime.Remoting/2.0.0.0__b77a5c561934e089/System.Runtime.Remoting.dll
----------------------------------------
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
Microsoft.Office.Interop.Excel
Assembly Version: 14.0.0.0
Win32 Version: 14.0.4756.1000
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.Office.Interop.Excel/14.0.0.0__71e9bce111e9429c/Microsoft.Office.Interop.Excel.dll
Im sorry for late reply can you pls mail me(kindhu@gmail.com) with the details, on which OS you tried and at what step this error occurred.
Could not load file or assembly 'Microsoft.Office.Interop.Excel, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified.
File name: 'Microsoft.Office.Interop.Excel, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c'
please help me and my emial is upadhyaymaharshi@gmail.com
Please send me code in c# .net
Hi, i have one question, is ist possible to add a picture to every contact?. It could be a great idea
Unhandles exception has occured in your application. If you click continue, the application will ignore this error and attempt to continue. If you click Quit, the application will close immediately.
Could not load file or assembly 'Microsoft.Office.Interop.Excel..... That has been the error am having each time I click on select excel file. How do I fix this? Thanks
Free goods convert excel to vcf https://goo.gl/7ceP6y
Try Excel to vCard Converter to export the Excel data to VCF format without any data alteration. Users can effectively preview all the Excel fields along with rows and columns before the final conversion process. The best Excel to vCard Converter assures no data loss while exporting the files formats. Users can batch convert the files format at once without any technical assistance. It supports all the MS Excel files formats and this utility can be easily operated on any Windows OS.
For more details visit:- Excel to VCF Converter
Post a Comment