skanmera / excelmerge Goto Github PK

View Code? Open in Web Editor NEW

686.0 43.0 123.0 4.67 MB

GUI Diff Tool for Excel

C# 99.99% Visual Basic 0.01%

excel csharp csv diff gui-diff gui diff-tool winmerge

excelmerge's People

Contributors

Stargazers

Watchers

Forkers

sujang rhinojosa dingmingxin narazaka pinkuburu kimi-liver ruo2012 ericwjp endlmk sleepbanana a207a207 0duru1 excel-projects cccoing yang123vc stevenhw luismejiialeon lsq lynnlake massimosporchia ligengrong cooper-a locnguyenhuu jackking2015 nukash itluobo geniushuai murakumo1927 ddwafer jasongrass liweizl ifnt fengxingdy korakrit-c schifflee makeskycode kjoyh202 k-fujimaru c4stou ryan10328 radtek longfeilove7 tootwototwotoo dacheng-wang keeptotheend crosslife kmuffato marioferyhwh mucahiddanis enriqueantonio-maker zl1030 teahouse bunarnar lauskyun 15831944 codygit meimei517514 bellyfat zkactivity ixgsoul diegobayonag mmsgau studywithjeffrey augustinusanthony j2vdeveloper xinqinglhj wangjingmin dongbum tevfikoguz dafengz assassinlx casually kanotoinrok babbio95 mystlive moremoredaa elysees exchideas fwo-20190107 joostvanwoerkom selo0530 endolith leonacn laifang wy-hangwang mmx5 enahue gotoh gangaji15519 stormshynn saberzan orgemagi208 zhouligong michael811125 gabrieldelaparra destr1zzj dlwhgc-119 david0718 lunar-qin zeynelkandil

excelmerge's Issues

[Feature Request]

This tool looks amazing! Could i bother you with some feature requests?

1: When a user scrolls past the end of a sheet diff, automatically jump to the next sheet in both src and dst and extract. For user convenience. Make this configurable?

[EDIT] Your showcase gif shows exactly this, perhaps there is a way to do this i am overlooking

2: Add a flag or option for more automated workbook diff:

Assume i have two versions of the same excel workbook. The sheets are in the same order and have the same names. There have been changes on some sheets (mostly row additions, cell edits).

Right now, the user has to click his way through the gui to change the sheet for both source and dest files and then "extract diff". #1 would already help, but I would like for the tool to diff all sheets to begin with (under the checked assumption all sheets have the same names and order), and then perhaps mark sheets with diffs in the sheet selection dropdown (color them red or something). Have the GUI jump to the first (sheet) diff.

Add horizontal scroll

Please add horizontal scroll via Shift+MouseWheel.

Option to scan all sheets while opening

Hi there,
thanks for your awesome piece of software! So far the best Excel compare / merge tool I've seen!

My feature request is the option to scan all sheets on opening ExcelMerge and show a summery of all diffs in all sheets. So far, ExcelMerge only informs you if there are no diffs on the first sheet (the message in the popup might be misinterpreted "there are no diffs").
Would be nice to extend the scope of this message on all sheets.

Thank you!

It is better to accept upper case extension like .CSV

ExcelMege get error on reading "foo.CSV" because its extension does not match with lower case ".csv".
Also .TSV is.

when the merge feature come？

hi, guy
We are in need of such a tool contains excel merge feature，when would the merge feature come？

To which CSV Diff application does the readme refer?

The readme for this project states: "ExcelMerge is a graphical display tool for Excel or CSV Diff."

To which "CSV Diff" application does the readme refer?

How to use ExcelMerge as a external svn diff tool ?

Run v1.2.0 and crashed

Run and turned out ExcelMerge.GUI has stoped working.

My OS is Windows 7 Service Pack 1

When the support for .xlsm will be added

Exception thrown: 'System.FormatException' in mscorlib.dll

System.FormatException occurred
  HResult=0x80131537
  Message=Nieprawidłowy format ciągu wejściowego.
  Source=<Cannot evaluate the exception source>
  StackTrace:
   at System.Number.ParseDouble(String value, NumberStyles options, NumberFormatInfo numfmt)
   at System.String.System.IConvertible.ToDouble(IFormatProvider provider)
   at System.Convert.ToDouble(Object value)
   at ExcelMerge.GUI.ValueConverters.PercentageConverter.Convert(Object value, Type targetType, Object parameter, CultureInfo culture) in C:\DOWNLOADS\GitHub\ExcelMerge\ExcelMerge.GUI\ValueConverters\PercentageConverter.cs:line 16
   at System.Windows.Data.BindingExpression.TransferValue(Object newValue, Boolean isASubPropertyChange)
   at System.Windows.Data.BindingExpression.Activate(Object item)
   at System.Windows.Data.BindingExpression.AttachToContext(AttachAttempt attempt)
   at System.Windows.Data.BindingExpression.AttachOverride(DependencyObject target, DependencyProperty dp)
   at System.Windows.Data.BindingExpressionBase.OnAttach(DependencyObject d, DependencyProperty dp)
   at System.Windows.DependencyObject.SetValueCommon(DependencyProperty dp, Object value, PropertyMetadata metadata, Boolean coerceWithDeferredReference, Boolean coerceWithCurrentValue, OperationType operationType, Boolean isInternal)
   at System.Windows.Baml2006.WpfKnownMemberInvoker.SetValue(Object instance, Object value)
   at MS.Internal.Xaml.Runtime.ClrObjectRuntime.SetValue(XamlMember member, Object obj, Object value)
   at MS.Internal.Xaml.Runtime.ClrObjectRuntime.SetValue(Object inst, XamlMember property, Object value)

Exception can not set CaretPosition outside RichTextBox

Exception:

Repro:

Select row with some changes
Press Ctrl+B
Clear the powershell console (Ctrl+A, Del)
Select row with some changes
Press Ctrl+B
Exception shows

Fails upon opening target spreadsheet

Hi,

I get this error when trying to merge specific Excel sheets. I don't know what ExcelMerge is choking on, and I'm unfortunately not able to share the file.

Crash when comparing specific files

I opened some file, then, compared sheets made crash.
I tried to compare same files, then crash. Other files don't crash app.

I took a stacktrace.

アプリケーション:ExcelMerge.GUI.exe
フレームワークのバージョン:v4.0.30319
説明: ハンドルされない例外のため、プロセスが中止されました。
例外情報:System.IO.IOException
場所 System.IO.__Error.WinIOError(Int32, System.String)
場所 System.IO.FileStream.Init(System.String, System.IO.FileMode, System.IO.FileAccess, Int32, Boolean, System.IO.FileShare, Int32, System.IO.FileOptions, SECURITY_ATTRIBUTES, System.String, Boolean, Boolean, Boolean)
場所 System.IO.FileStream..ctor(System.String, System.IO.FileMode, System.IO.FileAccess)
場所 NPOI.SS.UserModel.WorkbookFactory.Create(System.String)
場所 ExcelMerge.ExcelWorkbook+d__6.MoveNext()
場所 System.Collections.Generic.List1[[System.__Canon, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]..ctor(System.Collections.Generic.IEnumerable1<System.__Canon>)
場所 System.Linq.Enumerable.ToList[System.__Canon, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]
場所 ExcelMerge.GUI.ViewModels.DiffViewModel.UpdateExecutableFlag()
場所 ExcelMerge.GUI.ViewModels.DiffViewModel.set_DstPath(System.String)
場所 ExcelMerge.GUI.ViewModels.DiffViewModel..ctor(System.String, System.String, ExcelMerge.GUI.ViewModels.MainWindowViewModel)
場所 ExcelMerge.GUI.Commands.DiffCommand.Execute()
場所 ExcelMerge.GUI.App.OnStartup(System.Windows.StartupEventArgs)
場所 System.Windows.Application.<.ctor>b__1_0(System.Object)
場所 System.Windows.Threading.ExceptionWrapper.InternalRealCall(System.Delegate, System.Object, Int32)
場所 System.Windows.Threading.ExceptionWrapper.TryCatchWhen(System.Object, System.Delegate, System.Object, Int32, System.Delegate)
場所 System.Windows.Threading.DispatcherOperation.InvokeImpl()
場所 System.Windows.Threading.DispatcherOperation.InvokeInSecurityContext(System.Object)
場所 System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
場所 System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
場所 System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object)
場所 MS.Internal.CulturePreservingExecutionContext.Run(MS.Internal.CulturePreservingExecutionContext, System.Threading.ContextCallback, System.Object)
場所 System.Windows.Threading.DispatcherOperation.Invoke()
場所 System.Windows.Threading.Dispatcher.ProcessQueue()
場所 System.Windows.Threading.Dispatcher.WndProcHook(IntPtr, Int32, IntPtr, IntPtr, Boolean ByRef)
場所 MS.Win32.HwndWrapper.WndProc(IntPtr, Int32, IntPtr, IntPtr, Boolean ByRef)
場所 MS.Win32.HwndSubclass.DispatcherCallbackOperation(System.Object)
場所 System.Windows.Threading.ExceptionWrapper.InternalRealCall(System.Delegate, System.Object, Int32)
場所 System.Windows.Threading.ExceptionWrapper.TryCatchWhen(System.Object, System.Delegate, System.Object, Int32, System.Delegate)
場所 System.Windows.Threading.Dispatcher.LegacyInvokeImpl(System.Windows.Threading.DispatcherPriority, System.TimeSpan, System.Delegate, System.Object, Int32)
場所 MS.Win32.HwndSubclass.SubclassWndProc(IntPtr, Int32, IntPtr, IntPtr)
場所 MS.Win32.UnsafeNativeMethods.DispatchMessage(System.Windows.Interop.MSG ByRef)
場所 System.Windows.Threading.Dispatcher.PushFrameImpl(System.Windows.Threading.DispatcherFrame)
場所 System.Windows.Threading.Dispatcher.PushFrame(System.Windows.Threading.DispatcherFrame)
場所 System.Windows.Application.RunDispatcher(System.Object)
場所 System.Windows.Application.RunInternal(System.Windows.Window)
場所 System.Windows.Application.Run(System.Windows.Window)
場所 ExcelMerge.GUI.App.Main()

App version 1.3.4
OS Windows7 64bit
I tried .NET-check. All framework versions are installed after 2.0.

when the support for chinese?

Table area only shows the diff of sheet1

There are 2 sheets in those Excel files, and cells of sheet2 are different:

Seems like it's not capable to show the diff of sheet2:

Is this feature under developing or it's a BUG?

Git diff not working

windiff = difftool -g -y -t ExcelMerge throwing error
"fatal: --gui, --tool and --extcmd are mutually exclusive" in newer version of git. Earlier it use to work

Unable to find version '1.0.2' of package 'SKCore.Wpf'

Trying to build the project, but the package 'SKCore.Wpf.1.0.2' is not found.

Encoding of CSV

In current version, UTF-8 is always used on reading CSV file.
But it might be better to use Encoding.Default instead
because Japanese version of Excel uses Shift_JIS (== Encoding.Default)
on saving as csv.

User installation without admin provileges

Please allow user installation without admin privileges.

Problem installing on Windows 10 LTSB

Does the installion need any software, patches, or anything to install before?
I have tried to install on a Windows 10 LTSB (x64bits) and I got the following error in the installation of ExcelMergeSetup_v1.4.0.msi installer:
"There is a problem with this Windows Installer package. A script required for this install to complete could not be run."

I attach a screenshot.

Thank you!

The FastGridControl rendering proplem.

Hi all,

I have tried the FastGridControl source in your project, but there is a minor issue that the layout is buggy when rendering in the maximized window (See the pictures below). I don't why it happened. Any ideas?

The normal state of the window, the rendering is quite good

After maximizing the window, the text is buggy. I have no idea!!

Any idea in this case? Thanks.