private void SetExcelLine(Excel excel, VideoMediaInfo metadata, string filePath, int numStr, double encodeFps)
{
excel.SetValue(String.Format("A{0}", numStr), encodeFps.ToString(CultureInfo.InvariantCulture));
excel.SetValue(String.Format("B{0}", numStr), metadata.VideoDuration.ToString(CultureInfo.InvariantCulture));
excel.SetValue(String.Format("C{0}", numStr), metadata.VideoFrameRate.ToString(CultureInfo.InvariantCulture));
excel.SetValue(String.Format("D{0}", numStr), metadata.VideoFormatSettingsGOP.ToString(CultureInfo.InvariantCulture));
excel.SetValue(String.Format("E{0}", numStr), metadata.VideoWidth.ToString(CultureInfo.InvariantCulture));
excel.SetValue(String.Format("F{0}", numStr), metadata.VideoHeight.ToString(CultureInfo.InvariantCulture));
excel.SetValue(String.Format("G{0}", numStr), metadata.GeneralFormat);
excel.SetValue(String.Format("H{0}", numStr), metadata.VideoFormat);
excel.SetValue(String.Format("I{0}", numStr), metadata.VideoFormatProfile);
excel.SetValue(String.Format("J{0}", numStr), metadata.VideoBitRate.ToString(CultureInfo.InvariantCulture));
excel.SetValue(String.Format("K{0}", numStr), metadata.AudioFormat);
excel.SetValue(String.Format("L{0}", numStr), metadata.AudioFormatProfile);
excel.SetValue(String.Format("M{0}", numStr), metadata.AudioBitRate.ToString(CultureInfo.InvariantCulture));
excel.SetValue(String.Format("N{0}", numStr), metadata.AudioChannels.ToString(CultureInfo.InvariantCulture));
excel.SetValue(String.Format("O{0}", numStr), metadata.GeneralFileSize.ToString(CultureInfo.InvariantCulture));
excel.SetValue(String.Format("P{0}", numStr), filePath);
}
private Excel CreateExcel()
{
var excel = new Excel();
excel.NewDocument();
excel.SetValue("A1", "Encode FPS");
excel.SetValue("B1", "Duration Time");
excel.SetValue("C1", "Video FPS");
excel.SetValue("D1", "Video Key Frame");
excel.SetValue("E1", "Width");
excel.SetValue("F1", "Height");
excel.SetValue("G1", "Container");
excel.SetValue("H1", "Video Codec");
excel.SetValue("I1", "Video Profile");
excel.SetValue("J1", "Video Bitrate");
excel.SetValue("K1", "Audio Codec");
excel.SetValue("L1", "Audio Profile");
excel.SetValue("M1", "Audio Bitrate");
excel.SetValue("N1", "Audio Channel");
excel.SetValue("O1", "File Size");
excel.SetValue("P1", "File Path");
return excel;
}