NX/UG二次开发—其他—Excel文件的读写方案

可以不用考虑电脑上安装的是WPS还是Office

libpartutils.dll
int SPDSHT_add_worksheet(int,char const *,int *)
int SPDSHT_append_row(int,int,int,char const * *)
int SPDSHT_ask_cell_formula(int,int,int,int,int *,char * *)
int SPDSHT_ask_number_of_worksheets(int,int *)
int SPDSHT_ask_worksheet_index(int,char const *,int *)
int SPDSHT_ask_worksheet_name(int,int,char * *)
int SPDSHT_autofit_columns(int,int,int,int)
int SPDSHT_calculate_worksheet(int,int)
int SPDSHT_clear_range(int,int,int,int,int,int)
void SPDSHT_close_all_opened_file(void)
int SPDSHT_close_spreadsheet_file(int,bool)
int SPDSHT_close_spreadsheet_file_in_port(char const *,int)
int SPDSHT_create_new_port(int *)
int SPDSHT_delete_all_record(int,char const *)
int SPDSHT_delete_column(int,int,int)
int SPDSHT_delete_range(int,int,int,int,int,int)
int SPDSHT_delete_row(int,int,int)
int SPDSHT_delete_worksheet_by_index(int,int)
int SPDSHT_delete_worksheet_by_name(int,char const *)
int SPDSHT_delete_worksheets_except_first(int)
int SPDSHT_export_spreadsheet_file(char const *,char * *)
int SPDSHT_find_cell_in_column(int,int,int,char const *,int *)
int SPDSHT_find_cell_in_range(int,int,int,int,int,int,char const *,int *,int *)
int SPDSHT_find_cell_in_row(int,int,int,char const *,int *)
void SPDSHT_format_row_column(int,int,char * *)
void SPDSHT_free_range_content(struct SPDSHT_range_content_s * *)
int SPDSHT_get_range_of_used_cells(int,int,int *,int *,int *,int *)
int SPDSHT_insert_image(int,struct SPDSHT_range_s *,char const *)
bool SPDSHT_is_port_valid(int)
int SPDSHT_merge_cell_range(int,struct SPDSHT_range_s *)
int SPDSHT_open_new_native_spreadsheet_file(char const *,int *)
int SPDSHT_open_spreadsheet_file(char const *,int,int *)
int SPDSHT_open_spreadsheet_file_in_port(char const *,int,bool)
int SPDSHT_read_cell(int,int,int,int,int *,char * *)
int SPDSHT_read_named_range(int,int,char const *,int *,struct SPDSHT_range_content_s * * *)
int SPDSHT_read_range(int,struct SPDSHT_range_s *,int *,struct SPDSHT_range_content_s * *)
int SPDSHT_save_as(int,int,char const *,enum SPDSHT_excel_File_Format_e)
int SPDSHT_set_cell_formula(int,int,int,int,char const *)
int SPDSHT_set_cell_text_format(int,int,int,int)
int SPDSHT_set_column_width(int,int,int,double)
int SPDSHT_set_current_spreadsheet(char const *,int)
int SPDSHT_set_range_alignment(int,int,int,int,int,int,enum SPDSHT_alignment_style_e,enum SPDSHT_text_alignment_mode_e)
int SPDSHT_set_range_background_color(int,struct SPDSHT_range_s *,unsigned long)
int SPDSHT_set_range_borders_property(int,struct SPDSHT_range_s *,unsigned long,enum SPDSHT_border_line_style_e)
int SPDSHT_set_range_font_property(int,struct SPDSHT_range_s *,char const *,int,unsigned long,bool,bool,enum SPDSHT_underline_style_e,bool,bool,bool)
int SPDSHT_set_sheet_tab_background_color(int,int,unsigned long)
int SPDSHT_set_worksheet_name(int,int,char const *)
int SPDSHT_write_cell(int,int,int,int,char const *)
int SPDSHT_write_range(int,struct SPDSHT_range_content_s *)

libkru.dll
class UGS::Tooling::Excel::Cell
class UGS::Tooling::Excel::Worksheet
class UGS::Tooling::Excel::Workbook
class UGS::Tooling::Excel::Reader2010